Re: [GENERAL] Reindex taking forever, and 99% CPU

2014-08-06 Thread Alexey Klyukin
fter it). I'd question the usefulness of running VACUUM FULL on a production server (there are other ways around, i.e pg_repack or some ideas from this post: http://www.depesz.com/2013/06/21/bloat-removal-by-tuples-moving/). -- Regards, Alexey Klyukin

Re: [GENERAL] Do we want SYNONYMS?

2010-12-13 Thread Alexey Klyukin
, but also, if we do, then for which kinds of objects? > > In any case, references to remote objects such as Oracle can do > seem like an entirely separate issue. I'd prefer to avoid the Oracle > terminology, if only to avoid confusion with that feature. Agreed as well

Re: [GENERAL] Do we want SYNONYMS?

2010-12-13 Thread Alexey Klyukin
is. This could possibly lead to performance issues , and there would be no error or warning message if you occasionally drop the oldschema.oldname, rendering the newschema.newname useless. /A -- Alexey Klyukin http://www.CommandPrompt.com/ The PostgreSQ

Re: [GENERAL] Large Objects and Replication question

2009-12-02 Thread Alexey Klyukin
rg/ mentioned in the wiki page above > apparently does nothing to do with Slony-II. Can someone please fix it. Removed the link. -- Alexey Klyukin http://www.CommandPrompt.com/ The PostgreSQL Company - Command Prompt, Inc -- Sent via pgsql-general mailing list

Re: [GENERAL] Large Objects and Replication question

2009-12-02 Thread Alexey Klyukin
ates are tables and sequences. http://www.slony.info/documentation/slonyintro.html#INTRODUCTION I'm not sure that it's up-to-date, since 8.4 has at least on truncate triggers, but still there are no triggers on large objects yet. -- Alexey Klyukin http://www.C

Re: [GENERAL] plperl: spi_query_prepared/spi_fetchrow versus spi_exec_prepared: memory?

2009-11-17 Thread Alexey Klyukin
; also leaves that data in ram. however this: I wonder if sv_2mortal should be called for the return value from plperl_spi_exec and plperl_spi_exec_prepared in plperl.c.to to avoid a reference leak until the memory context is destroyed. -- Alexey Klyukin http://www.

Re: [GENERAL] Looking for way to replicate master db to multiple mobile databases

2009-09-24 Thread Alexey Klyukin
. These slaves connect to the replication server for some configurable period of time, get the new data, and disconnect until the next attempt. > > However, I thought I'd see if anyone is doing something similar and what > thoughts there might be out there as to a better way to accomplish th

Re: [GENERAL] Calculating the difference between timetz values

2009-07-27 Thread Alexey Klyukin
On Jul 27, 2009, at 6:52 PM, Michael Glaesemann wrote: On Jul 27, 2009, at 10:54 , Alexey Klyukin wrote: Hello, I was looking for a way to get the difference (interval) between 2 timetz values, i.e.: I don't have a solution, but am curious what your use case is for timetz (as op

[GENERAL] Calculating the difference between timetz values

2009-07-27 Thread Alexey Klyukin
t a correct solution for the problem above due to the loss of all TZ information. Regards, -- Alexey Klyukin http://www.CommandPrompt.com The PostgreSQL Company - Command Prompt, Inc. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] status of pl/php

2009-04-27 Thread Alexey Klyukin
r question - 1.3.5-beta1 is the most recent release, anything older is probably unusable or doesn't work with 8.3 -- Alexey Klyukin http://www.CommandPrompt.com The PostgreSQL Company - Command Prompt, Inc. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make