Hi,
Then we must know what is your collation…
What is the collation of your database?
select datname, pg_catalog.pg_encoding_to_char(encoding) "encoding",
datcollate, datctype
from pg_database;
It is also possible to define an explicit collation for the column. You can
have it when
On Sat, 22 May 2021 at 10:59, Nagaraj Raj wrote:
> ERROR: empty range bound specified for partition "mytable_z" DETAIL:
> Specified lower bound ('Z') is greater than or equal to upper bound ('[').
> SQL state: 42P17
It looks like '[' does not come after 'Z' in your collation.
David
On Sat, 22 May 2021 at 04:38, Nagaraj Raj wrote:
> I am trying to create partitions on the table which have around 2BIL records
> and users will always look for the "name", its not possible to create a
> partition with a list, so we are trying to create a partition-based first
> letter of the n
sorry, forgot to attach the test cases.Postgres 13 | db<>fiddle
|
|
| |
Postgres 13 | db<>fiddle
Free online SQL environment for experimenting and sharing.
|
|
|
On Friday, May 21, 2021, 03:59:18 PM PDT, Nagaraj Raj
wrote:
Hi,
This is also not working,
create table my
Hi,
This is also not working,
create table mytable_z partition of mytable for values from ('Z') to
('[')partition by range(id);
ERROR: empty range bound specified for partition "mytable_z"DETAIL: Specified
lower bound ('Z') is greater than or equal to upper bound ('[').SQL state: 42P17
DB ru
Hi
I don’t discuss here the choice itself but this is not correct:
create table mytable_z of mytable for values from ('Z') to ('Z[');
It should be
create table mytable_z of mytable for values from ('Z') to ('[')
Michel SALAIS
De : Nagaraj Raj
Envoyé : vendredi 21 mai 2021 18:39
> select * from t1 where name = somename ? == equality match // if yes, hash
> partitioning may be helpful to a have reasonably balanced distribution
yes, its an equality check,
On Friday, May 21, 2021, 12:08:25 PM PDT, Vijaykumar Jain
wrote:
just out of curiosity,what would a typ
just out of curiosity,
what would a typical query be ?
select * from t1 where name = somename ? == equality match // if yes,
hash partitioning may be helpful to a have reasonably balanced distribution
or
select * from t1 where name like 'some%'; what would be the
distribution of rows for
Hi David,
Hi,
I am trying to create partitions on the table which have around 2BIL records
and users will always look for the "name", its not possible to create a
partition with a list, so we are trying to create a partition-based first
letter of the name column. name column has a combination o
perfect :-)
thanks
Marc MILLAS
Senior Architect
+33607850334
www.mokadb.com
On Fri, May 21, 2021 at 3:21 PM Andrew Dunstan wrote:
>
> On 5/21/21 8:41 AM, Marc Millas wrote:
> > Hi,
> >
> > my POC in postgres 12.(important ?)
> >
> > if I setup 2 postgres clusters, and create a publication in
On 5/21/21 8:41 AM, Marc Millas wrote:
> Hi,
>
> my POC in postgres 12.(important ?)
>
> if I setup 2 postgres clusters, and create a publication in one and a
> subscription in the other,
> and do on the pub an update which does not change the data (updating
> an existing record with same data) t
Hi,
my POC in postgres 12.(important ?)
if I setup 2 postgres clusters, and create a publication in one and a
subscription in the other,
and do on the pub an update which does not change the data (updating an
existing record with same data) then this (useless) update go through
replication.(ie co
On Fri, 21 May 2021 at 19:02, Nagaraj Raj wrote:
> then what would be the range of Z
> FROM (Z) to (?) ;
postgres=# select chr(ascii('z')+1) ;
chr
-
{
(1 row)
> same way for 9
postgres=# select chr(ascii('9')+1) ;
chr
-
:
(1 row)
https://en.wikipedia.org/wiki/ASCII
You can also u
So what about 'Z' or 'z' and 9?
I created the partitions tables FROM (A) to (B) ;FROM (B) to (C) ;
.. FROM (Y) to (Z) ;
then what would be the range of ZFROM (Z) to (?) ;
same way for 9 On Thursday, May 20, 2021, 07:38:50 PM PDT, Justin Pryzby
wrote:
On Fri, May 21, 2021 at 02:36:14AM
14 matches
Mail list logo
