Hello,
I'm trying to tune the parameters in postgres.conf to improve the
performance of my database (where performance = 'make queries run
faster'). I would be very grateful if you could give me some comments
about my choice of configuration settings below (did I do anything
very silly?
On Sun, Aug 29, 2010 at 06:02:14PM +0100, Dario Beraldi wrote:
Hello,
I'm trying to tune the parameters in postgres.conf to improve the
performance of my database (where performance = 'make queries run
faster'). I would be very grateful if you could give me some comments
about my
Do check a previous thread:
http://www.mail-archive.com/pgsql-general@postgresql.org/msg149691.html
On Sun, Aug 29, 2010 at 10:32 PM, Dario Beraldi dario.bera...@ed.ac.ukwrote:
Hello,
I'm trying to tune the parameters in postgres.conf to improve the
performance of my database (where
And don't forge the wiki!
http://wiki.postgresql.org/wiki/Performance_Optimization
On Sun, Aug 29, 2010 at 12:14 PM, Sandeep Srinivasa s...@clearsenses.com
wrote:
Do check a previous thread:
http://www.mail-archive.com/pgsql-general@postgresql.org/msg149691.html
On Sun, Aug 29, 2010 at
On ons, 2010-08-25 at 00:15 -0700, wstrzalka wrote:
I'm currently playing with very large data import using COPY from
file.
As this can be extremely long operation (hours in my case) the nice
feature would be some option to show operation progress - how many
rows were already imported.
A
Hi,
We had by mistake dropped the referencial integrety between two huge tables
and now I'm facing the following messages when trying to recreate the
foreign key again:
alter table posicoes_controles add
CONSTRAINT protocolo FOREIGN KEY (protocolo)
REFERENCES posicoes (protocolo) MATCH
On Mon, Aug 30, 2010 at 5:30 AM, Carlos Henrique Reimer
carlos.rei...@opendb.com.br wrote:
Hi,
We had by mistake dropped the referencial integrety between two huge tables
and now I'm facing the following messages when trying to recreate the
foreign key again:
alter table posicoes_controles
Hi,
Yes, this is a good suggestion but as the table posicoes_controles has
3.71172e+008 rows it will perform 3.71172e+008 selects against table
posicoes to check if the protocolo is in table.
I was think something like:
explain delete from posicoes_controles where protocolo not in (select
