Hi All ,
Am using postgres version 9.0.1 .
In daily postgres log am getting same kind of log for many time , is it
because of more table creation and deletion is going on and its trying to
vaccum pg_shdepend ?
But its getting canceled every time , why is it so ?
2013-02-05 00:00:09 CST [25319]: [
Hi ,
Am running near about 10 databases on one cluster , out of this i want to
replicate one database to another server where allready some databases are
running , is any tool is der in postgres which can replicate only one
database at a time.
--
--Regards
Ranjeet R. Dhumal
Hi Pavel ,
For Tunning this which parameter i have to change from the configuration
, and at the time of setting it up which thinks i have to care i mean what
will be the impact of that ?
On 26 November 2012 12:09, Pavel Stehule wrote:
> Hello
>
> 2012/11/26 Ranjeet Dhumal :
&
Hi All ,
Am facing one problem related to pg_toast table , its grown very huge upto
31GB , even am vacuuming(not full) it daily , my fsm parameters are
default, can anyone tell how to decrease the size , if am firing any query
on gen_bulk_20121126 its response time is very slow as compared to fe
Hi Tom ,
Sorry but i didn't understand that If this is a bug from postgres version
then how the same query will be worked if i recreated the tables and with
same version of postgres.
On 21 November 2012 19:53, Tom Lane wrote:
> Alban Hertroys writes:
> >> Ranjeet Dhumal w
happening suddenly because for same table and everything is working fine
without error .
On 21 November 2012 18:14, Albe Laurenz wrote:
> Ranjeet Dhumal wrote:
> > When am trying to query a table temp_table1(sms_type
> varchar(20),sms_info varchar(100),sms_id integer)
> &g
Hi All ,
When am trying to query a table temp_table1(sms_type varchar(20),sms_info
varchar(100),sms_id integer)
Query :: select sms_type,count(*) from temp_table1 group by 1 order by 2
desc;
Then i got following errors , i dont know whats wrong in this .
*ERROR: volatile EquivalenceClass has no s
