Matthew T. O'Connor writes:
In many instances the default thresholds for autovacuum are too
conservative. You can try making it more aggressive and see what
happens, you can do this generally, or on a table specific basis.
I think something is very wrong with the estimates I am getting back.
"Ken Winter" <[EMAIL PROTECTED]> writes:
> Im trying to do a data-only pg_restore. Im running into a roadblock
> whenever the restore tries to populate a table with a foreign key before it
> has populated the primary key table that it refers to: This violates the FK
> constraint, which aborts th
I would think .cu == spanish?
en la programa "psql" uso
\dt
también, hay una lista española: [EMAIL PROTECTED]
Robert Treat
On Sunday 06 August 2006 05:33, Marco Bizzarri wrote:
> Sorry, I will try to answer in english and in italian, if you're able
> to understand either:
>
> from psql
Francisco Reyes wrote:
Using 8.1.4
Have autovacuum running and it shows on the logs as running.
Ever couple of days in the last week when I tried to run vacuum analyze
postgresql complained that I needed to increase my fsm_pages.
I am going to start scheduling vacuum analyze in crontab.. but i
Martijn van Oosterhout writes:
My question is, is autovacuum expected to work in situations like this where I
have a long lived connection to the database ? After I shutdown my application,
I am having a simmilar situation, but I am just starting to debug it.
Using 8.1.4
Have autovacuum runni
I am getting an error message when initdb
run
The program
/usr/bin/postgresql
need by initdb does not belong to PostgreSQL
7.4.7 or
there may be a configuration problem.
Any body have any idea?
Rapidigm
(A Fujitsu
Consulting Company)
Scott Clement
Sr. Systems
Administr
Im trying to do a data-only pg_restore. Im running into a roadblock
whenever the restore tries to populate a table with a foreign key before it
has populated the primary key table that it refers to: This violates the FK
constraint, which aborts the restore.
Given the complexity of the database
# [EMAIL PROTECTED] / 2006-08-06 11:47:43 +0200:
> the following function is created properly:
> CREATE OR REPLACE FUNCTION insert_into_table_overview(text, chr integer)
> RETURNS void AS '
> DECLARE
> in_tableALIAS FOR $1;
> p RECORD;
> BEGIN
> RAISE NOTICE '
Hi list,
the following function is created properly:
CREATE OR REPLACE FUNCTION insert_into_table_overview(text, chr integer)
RETURNS void AS '
DECLARE
in_tableALIAS FOR $1;
p RECORD;
BEGIN
RAISE NOTICE ''in_table = %'', in_table;
FOR p IN EXECUTE '
Sorry, I will try to answer in english and in italian, if you're able
to understand either:
from psql prompt:
\dt
Regards
Marco
Mi spiace, provero' a rispondere in inglese o in italiano, se riesci a
leggere uno dei due:
dal prompt di psq:
\dt
Saluti
Marco
On 8/6/06, Feri@ <[EMAIL PROTECTED
# [EMAIL PROTECTED] / 2006-08-05 19:32:27 +0200:
> I stop the postmaster service and then i copy the directory in an other place.
> Restart the postmaster and then test someting modifications.
> Then i stop the service and restore the saved data directory
> Now the postmaster dont start any more
>
11 matches
Mail list logo
