#x27; # This is only
example path
---
If yes then may I know how it is used and how it impacts database performance?
Regards:
Saurabh
you please tell me the purpose of shared_buffer and
maintenance_work_mem parameter?
Thanks,
Saurabh
--
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance
Thank you for the information.
Schema of table is:
ID bigint
company_name text
data_settext
time timestamp
Date date
Length of company_name is not known so it is of datatype text. I need
to build the index on co
performance reduced to 1/8th times. My question is how I
can improve performance when inserting data using index on text
column?
Thanks,
Saurabh
--
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql
Thank you all for the valuable information. Now we have decide to go
with streaming replication. I did the setup on machine and it is
working good. Now I have to implement the automatic failover. Please
share a solution for the same.
Saurabh Gupta
--
Sent via pgsql-performance mailing list
executes on slave, slave
starts lagging by master and as soon as query completes log files get
applied immediately. Please help how can I avoid slave lag.
Thanks
Regards
Saurabh Agrawal
--
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
To make changes to your
Thanks all for your valuable comments, as I gather, what I need to do is to
check the queries that are slow and do a vacuum analyze and share the
results along with postgresql.conf being used.
I will work on that.
Thanks again,
Saurabh
On Tue, Jul 7, 2009 at 4:46 AM, justin wrote:
> Saur
tion developer like me, it becomes more
of a trial and error kind of frustrating process.
If there a utility that understands the system specification on which
postgres is going to run and change the paramters accordingly, that would
help.
Thanks,
Saurabh
On Mon, Jul 6, 2009 at 12:37 PM, Guilla
.
Is there a utility that we can use that can check the system specification
and change the required parameters in postgresql.conf accordingly?
Thanks,
Saurabh
