Re: When to use PARTITION BY HASH?

2020-06-08 Thread Oleksandr Shulgin
On Sat, Jun 6, 2020 at 6:14 PM Michel Pelletier wrote: > > Well lets take a step back here and look at the question, hash > partitioning exists in Postgres, is it useful? While I appreciate the need > to see a fact demonstrated, and generally avoiding argument by authority, > it is true that man

Re: When to use PARTITION BY HASH?

2020-06-05 Thread Oleksandr Shulgin
On Thu, Jun 4, 2020 at 4:32 PM Jeff Janes wrote: > On Wed, Jun 3, 2020 at 7:55 AM Oleksandr Shulgin < > oleksandr.shul...@zalando.de> wrote: > > With hash partitioning you are not expected, in general, to end up with a >> small number of partitions being accessed more he

Re: When to use PARTITION BY HASH?

2020-06-03 Thread Oleksandr Shulgin
(sticking to pgsql-general) On Tue, Jun 2, 2020 at 7:45 PM Michel Pelletier wrote: > > On Tue, Jun 2, 2020 at 10:17 AM Oleksandr Shulgin < > oleksandr.shul...@zalando.de> wrote: > >> >> I was reading up on declarative partitioning[1] and I'm not sure what &g

Re: When to use PARTITION BY HASH?

2020-06-03 Thread Oleksandr Shulgin
On Tue, Jun 2, 2020 at 7:47 PM Stephen Frost wrote: > > Please don't cross post to multiple lists without any particular reason > for doing so- pick whichever list makes sense and post to that. > Sorry for the trouble, I should've checked it more carefully. When posting I did think it may be rel

When to use PARTITION BY HASH?

2020-06-02 Thread Oleksandr Shulgin
Hi! I was reading up on declarative partitioning[1] and I'm not sure what could be a possible application of Hash partitioning. Is anyone actually using it? What are typical use cases? What benefits does such a partitioning scheme provide? On its face, it seems that it can only give you a numb

Re: Queries on QMF to POSTGRE

2019-07-22 Thread Oleksandr Shulgin
-hackers +pgsql general On Sun, Jul 21, 2019 at 7:33 PM JVM . wrote: > > > I’m looking to convert QMF Queries , QMF forms and QMF procedure to the > POSTGRESQL will it support all of them. > > If yes please help us with the sample example. Or any Documentation. > What would help anyone willing

Re: Error on insert xml

2018-12-19 Thread Oleksandr Shulgin
On Wed, Dec 19, 2018 at 1:38 PM Михаил Яремчук wrote: > When I insert this data in the column with type xml, I get an error "SSL > SYSCALL error: EOF detected" and the gap of all current connections. When > I insert a simpler xml, but larger everything is ok. > version: PostgreSQL 9.6.11 on x86_6