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
protoc
On Mon, Aug 30, 2010 at 5:30 AM, Carlos Henrique Reimer
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 add
> CONSTRAINT pr
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 SI
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.
And don't forge the wiki!
http://wiki.postgresql.org/wiki/Performance_Optimization
On Sun, Aug 29, 2010 at 12:14 PM, Sandeep Srinivasa
wrote:
> 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 Beral
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 wrote:
> Hello,
>
> I'm trying to tune the parameters in postgres.conf to improve the
> performance of my database (where performance = 'make queries
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
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? A
