I am trying to test a simple case insensitive comparison. Most likely the
collation that I chose is wrong, but I'm not sure how to choose the correct
one (for English/US?). Here is my snippet:
create collation case_insensitive(
provider=icu, locale='en-US-x-icu', deterministic=false
);
selec
On Fri, Oct 11, 2019 at 1:09 AM stan wrote:
> On Thu, Oct 10, 2019 at 05:41:47AM -0700, Igal @ Lucee.org wrote:
> > On 10/9/2019 12:34 AM, Laurenz Albe wrote:
> > > Igal Sapir wrote:
> > > > I am trying to test a simple case insensitive comparison. Most
> li
I have a table for which pg_relation_size() shows only 31MB, but
pg_total_relation_size() shows a whopping 84GB.
The database engine is running inside a Docker container, with the data
mounted as a volume from a partition on the host's file system.
When I try to run `VACUUM FULL`, the disk usage
David,
On Sun, Apr 7, 2019 at 6:20 PM David Rowley
wrote:
> On Mon, 8 Apr 2019 at 10:09, Igal Sapir wrote:
> >
> > I have a table for which pg_relation_size() shows only 31MB, but
> pg_total_relation_size() shows a whopping 84GB.
> >
> > The database engine is run
David,
On Sun, Apr 7, 2019 at 7:28 PM David Rowley
wrote:
> On Mon, 8 Apr 2019 at 14:19, Igal Sapir wrote:
> >
> > On Sun, Apr 7, 2019 at 6:20 PM David Rowley <
> david.row...@2ndquadrant.com> wrote:
> >>
> >> On Mon, 8 Apr 2019 at 10:09, Igal Sapi
David,
On Sun, Apr 7, 2019 at 8:11 PM David Rowley
wrote:
> On Mon, 8 Apr 2019 at 14:57, Igal Sapir wrote:
> > However, I have now deleted about 50,000 rows more and the table has
> only 119,688 rows. The pg_relation_size() still shows 31MB and
> pg_total_relation_size() s
Pavel,
On Sun, Apr 7, 2019 at 11:22 PM Pavel Stehule
wrote:
>
> po 8. 4. 2019 v 7:57 odesílatel Igal Sapir napsal:
>
>> David,
>>
>> On Sun, Apr 7, 2019 at 8:11 PM David Rowley
>> wrote:
>>
>>> On Mon, 8 Apr 2019 at 14:57, Igal Sapir wrote:
>
Pavel,
On Mon, Apr 8, 2019 at 8:29 AM Pavel Stehule
wrote:
>
>
> po 8. 4. 2019 v 17:22 odesílatel Igal Sapir napsal:
>
>> Pavel,
>>
>> On Sun, Apr 7, 2019 at 11:22 PM Pavel Stehule
>> wrote:
>>
>>>
>>> po 8. 4. 2019 v 7:57 odesílatel
I have Postgres running in a Docker container with PGDATA mounted from the
host. Postgres consume all of the disk space, 130GB [1], and can not be
started [2]. The database has a lot of bloat due to much many deletions.
The problem is that now I can not start Postgres at all.
I mounted an additi
nk) for the
> base but I don't recall if that works or not.
>
> On Wed, May 1, 2019 at 18:07 Igal Sapir wrote:
>
>> I have Postgres running in a Docker container with PGDATA mounted from
>> the host. Postgres consume all of the disk space, 130GB [1], and can not
>>
Right. I managed to start up Postgres by symlinking the following
directories to a new mount: pg_logical, pg_subtrans, pg_wal, pg_xact.
I then created a new tablespace on the new mount, set it to be the default
tablespace, and moved some of the smaller (about 30GB) tables to it. That
allowed me
Jeff,
On Fri, May 3, 2019 at 6:56 AM Jeff Janes wrote:
> On Wed, May 1, 2019 at 10:25 PM Igal Sapir wrote:
>
>>
>> I have a scheduled process that runs daily to delete old data and do full
>> vacuum. Not sure why this happened (again).
>>
>
> If you are
r-- 1 root root 640M May 3 12:42 e76fc603ffe2c977c826.tmp
-rw-r--r-- 1 root root 640M May 3 12:42 fed72361b202f9492d7f.tmp
Best,
Igal
On Fri, May 3, 2019 at 9:09 AM Igal Sapir wrote:
> Jeff,
>
> On Fri, May 3, 2019 at 6:56 AM Jeff Janes wrote:
>
>> On Wed, May 1, 2019 at 10:25
Is it possible to connect to Postgres for notifications via telnet? This
is obviously more for learning/experimenting purposes.
I expected a simple way to connect and consume notifications but can not
find any example or documentation on how to do that.
Any ideas?
Thanks,
Igal
Thank you both (Michel replied off-list it seems),
On Fri, May 3, 2019 at 1:10 PM Andres Freund wrote:
> Hi,
>
> On 2019-05-03 11:06:09 -0700, Igal Sapir wrote:
> > Is it possible to connect to Postgres for notifications via telnet? This
> > is obviously more for l
Christoph,
On Sat, May 4, 2019 at 10:44 AM Christoph Moench-Tegeder
wrote:
> ## Igal Sapir (i...@lucee.org):
>
> > My main "issue" is that the official pgjdbc driver does not support the
> > notifications with listen and I was trying to figure out why.
>
Jeff,
On Sat, May 4, 2019 at 11:34 AM Jeff Janes wrote:
> On Sat, May 4, 2019 at 1:49 PM Igal Sapir wrote:
>
>> Christoph,
>>
>> On Sat, May 4, 2019 at 10:44 AM Christoph Moench-Tegeder <
>> c...@burggraben.net> wrote:
>>
>>> ## Igal Sapir
Jeff,
On Sat, May 4, 2019 at 2:10 PM Jeff Janes wrote:
> On Sat, May 4, 2019 at 3:04 PM Igal Sapir wrote:
>
>> Jeff,
>>
>> On Sat, May 4, 2019 at 11:34 AM Jeff Janes wrote:
>>
>>> On Sat, May 4, 2019 at 1:49 PM Igal Sapir wrote:
>>>
>>&g
Next month I'll be making a presentation about Postgres to a SQL Server
crowd in L.A. at their SQL Saturday event.
I was wondering if anyone has any tips that are specific for SQL Server
users? Best features? Known issues? Common rebuttals?
Thanks,
Igal
Ravi,
On Mon, May 6, 2019 at 12:28 PM Ravi Krishna wrote:
> > I was wondering if anyone has any tips that are specific for SQL Server
> users? Best features? Known issues? Common rebuttals?
>
> Are you talking about SS to PG migration.
>
> Generally SQLServer shops use SS specific functions a
Brent,
On Mon, May 6, 2019 at 1:44 PM Brent Wood wrote:
> Hi Igal,
>
> One relevant comment I found interesting a couple of years ago...
>
> A New Zealand Govt agency was installing an institutional GIS system
> (several thousand potential users). It supported different back-end spatial
> databa
Ron,
On Mon, May 6, 2019 at 12:54 PM Ron wrote:
> On 5/6/19 2:47 PM, Igal Sapir wrote:
> > but I want to instill confidence in them that anything they do with SQL
> > Server can be done with Postgres.
>
> Right off the top of my head, here are some things you can't (
Tony,
On Mon, May 6, 2019 at 10:35 PM Tony Shelver wrote:
> I have to agree on the geospatial (GIS) features.
> I converted from SQL Server to Postgresql for our extended tracking
> database. The SS geospatial feature set doesn't seem nearly as robust or
> complete or perfoirmant as that suppli
Brent,
On Tue, May 7, 2019 at 12:42 PM Brent Wood wrote:
> I have not used SS for spatial data, but I don't have a Postgres database
> without Postgis installed. The OSGEO ecosystem and synergies with other
> FOSS GIS tools is fantastic.
>
> And it does not stop with the Postgis extension. For t
I'm doing a presentation about Postgres to SQL Server users this weekend,
and I want to showcase some of the big names that use Postgres, e.g.
MasterCard, Government agencies, Banks, etc.
There used to be a Wiki page of Featured Users but that link is broken now.
I also "found" a page about Maste
On Tue, Jun 11, 2019 at 2:11 PM Chris Travers
wrote:
> At Adjust GmbH we have 5-10 PB data in Postgres.
>
>
> On Tue, Jun 11, 2019 at 9:28 PM Ireneusz Pluta/wp.pl wrote:
>
>> W dniu 2019-06-11 o 19:45, Igal Sapir pisze:
>> > I'm doing a presentation abou
Hello,
I am trying to pass a dynamic interval to generate_series() with date range.
This works as expected, and generates a series with an interval of 1 month:
SELECT generate_series(
date_trunc('month', current_date),
date_trunc('month', current_date + interval '7 month'),
interval
On Sun, Jun 30, 2024 at 3:51 PM Tom Lane wrote:
> Igal Sapir writes:
> > But this throws an error (SQL Error [42601]: ERROR: syntax error at or
> near
> > "'1 '"):
>
> > SELECT generate_series(
> > date_trunc('month', curren
I don't think that it's possible, but why don't you open a free gmail
account or another web-based email service that's available in your
region/language and subscribe to all of the mailing lists through that
account?
Igal
On Mon, Dec 25, 2017 at 2:49 AM, Michelle Konzack <
linux4miche...@tamay-
Hello,
I want to use the "UPSERT" syntax for returning an ID if it exists, or
inserting a record and returning the new ID if it does not exist.
INSERT INTO users(email, name)
VALUES('u...@domain.tld', 'User')
ON CONFLICT (email) DO NOTHING
RETURNING user_id, (xmax::text::int > 0) as existed
x::text::int > 0) as existed;
But if anyone has a better solution then I'd love to hear it.
Thanks,
Igal
On Mon, Jan 1, 2018 at 11:07 PM, Igal Sapir wrote:
> Hello,
>
> I want to use the "UPSERT" syntax for returning an ID if it exists, or
> inserting a re
update will return values while do nothing will not.
>
That explains it, thank you.
>
> 2018-01-02 15:43 GMT+08:00 Igal Sapir :
>
>> It seems that if I do a simple update it resolves my issue:
>>
>> INSERT INTO users(email, name)
>> VALUES('u...@domain.
Hi everybody,
I published a tool that makes it easy to migrate a database from other
DBMSs to Postgres:
https://github.com/isapir/Migrate2Postgres
Currently it supports migrations from MS SQL Server, but it is written in a
way that will make it easy to migrate from other DBMSs as well.
I also pu
33 matches
Mail list logo
