Re: Updating a pre-10 partitioned table to use PG 10 partitioning

On Thu, Jan 11, 2018 at 8:40 PM, Michael Paquier wrote: > On Thu, Jan 11, 2018 at 04:40:30PM +0100, Alban Hertroys wrote: > > What is a good approach here? > > By having a some point an origin and target table in the same cluster, > you would just need to define things properly. I have not checke

Re: characters converted to ??? in postgres

Yes it appears to be a separate issue but using OS X is the only way I could reproduce trying to see with my own eyes so to speak I did though a quick java program and that confirmed to me (at least so far) that the whole issue resides in the so called data object Thank you so much for help and

RE: Missing WAL file after running pg_rewind

The file exist in the archive directory of the old master but it is for the previous timeline, ie 5 and not 6, ie 0005038300BE. Can I just rename the file to 6 timeline? Ie 0006038300BE -Original Message- From: Michael Paquier [mailto:michael.paqu...@gmail.com] S

Re: pg_basebackup is taking more time than expected

It will not solve the problem, but maybe try with --checkpoint=fast option. -- Sent from: http://www.postgresql-archive.org/PostgreSQL-general-f1843780.html

Get IEEE754 bytes of real and double types for msgpack encoding

Hi, I am currently investigating whether I could have Postgres return its results in the msgpack [1] format and it seems someone already did most of the work: Patrik Simek came up with encoder and decoder functions [2]. Unfortunately it is lacking support for numbers in real and double format

Re: ADD OR ALTER column

On 12 January 2018 at 13:56, Rakesh Kumar wrote: > >I'm probably missing something, but can anyone see a reason why adding an > ADD OR >ALTER COLUMN syntax to the ALTER TABLE command isn't either a) > achievable or b) >desirable? > >It seems to me to be eminently useful and not overly difficult,

Sv: ADD OR ALTER column

På fredag 12. januar 2018 kl. 14:45:07, skrev Geoff Winkless < pgsqlad...@geoff.dj >: I'm probably missing something, but can anyone see a reason why adding an ADD OR ALTER COLUMN syntax to the ALTER TABLE command isn't either a) achievable or b) desirable?   It seems

Re: characters converted to ??? in postgres

On 1/11/18 20:52, armand pirvu wrote: > The -n flag worked fine on OS X. I don’t have this issue on Centos. As a side > question I wonder why was postgres built with libedit instead of libreadline > , just curious. You'll have to ask that of whoever built the binaries you are using. There are di

Re: ADD OR ALTER column

>I'm probably missing something, but can anyone see a reason why adding an ADD >OR >ALTER COLUMN syntax to the ALTER TABLE command isn't either a) achievable >or b) >desirable? >It seems to me to be eminently useful and not overly difficult, while >potentially >saving a significant amount of eff

ADD OR ALTER column

I'm probably missing something, but can anyone see a reason why adding an ADD OR ALTER COLUMN syntax to the ALTER TABLE command isn't either a) achievable or b) desirable? It seems to me to be eminently useful and not overly difficult, while potentially saving a significant amount of effort on the

Re: pg_basebackup is taking more time than expected

Greetings, * Raghavendra Rao J S V (raghavendra...@gmail.com) wrote: > We have database with the size of *425GB*. Out of this 425 GB, Around 40 to > 60% of space occupied by the indexes. Ram allocated to this machine is > 32GB and configuration parameters below. [...] > In order to take the backu

Incredibly slow queries on information_schema.constraint_column_usage?

Hello! We have a program which auto-generates tables and constraints, run against PostgreSQL 9.5. On startup, the program checks the current database schema to detect changes that are needed. For one of our database servers, some selects from information_schema are incredibly slow: select co

Re: String comparison problem in select - too many results

Durumdara: On Thu, Jan 11, 2018 at 1:23 PM, Durumdara wrote: > Dear Francesco! FrancIsco, with an I, Spanish, not Italian. > My "bug" is that I commonly used Windows environment where the default > collation is ANSI, based on Windows language which is Hungarian here > (Windows1250). I'm not s

pg_basebackup is taking more time than expected

Hi All, We have database with the size of *425GB*. Out of this 425 GB, Around 40 to 60% of space occupied by the indexes. Ram allocated to this machine is 32GB and configuration parameters below. max_connections = 800 shared_buffers = 9GB effective_cache_size = 18GB work_mem = 10MB maintenance_w