Hi John. Thanks a lot for your reply:
El día 1 de marzo de 2012 17:25, John R Pierce escribió:
> On 03/01/12 9:02 AM, Ruben Blanco wrote:
> specify host=localhost, otherwise its using the first 'local' line, which
> specifies 'ident' authentication, as the error imp
Hi:
I cannot connect to my Postgres database from my PHP scripts. I get the error:
PHP Warning: pg_connect(): Unable to connect to PostgreSQL server:
FATAL: Ident authentication failed for user "postgres" in ...
I have tried many combinations for "host" TYPE in "pg_hba.conf"
(restarting po
Hi, folks:
I'm trying to reduce execution time on a query using a partial index,
but Postgres doesn't make a significant improvement, even when the
partial index is 30 times smaller than the index used currently. Query
plan returns a slightly higher cost (cost=0.00..327952.12) for the
partial inde
Hi:
After partitioning a big table, I am getting slower performance on queries
run on the non-partitioned table (llamadas) than the partitioned table
(llamadas_maestra).
Not partitioned table:
heos_prod=# explain analyze select * from llamadas where cod_empresa=1
and fecha_llamada='2011062
Hi:
Is there anyway to create a unique index or constraint on part of a column?
Something like this, but something that works ;-)
ALTER TABLE invoices
ADD CONSTRAINT cons UNIQUE (EXTRACT(YEAR FROM invoice_date),
innvoice_number);
Thanks for any help.
Ruben,
Thanks a lot, guys. There were two users running Navicat, and these killer
queries are indeed run by this program.
Rubén.
2011/2/13 John R Pierce
> On 02/12/11 5:11 PM, Ruben Blanco wrote:
>
>> Hi:
>>
>> I'm running a Postgres database with a total disk occupation
Hi:
I'm running a Postgres database with a total disk occupation of 100Gb,
largest and most used table up to 40Gb (about 30.000.000 tuples).
Overall performance degrades sometimes due to some queries that are not run
by the final user app. I guess they are run by Postgres itself. They use to
take
Hi:
My database is growing fast taking too much disk space. How can I free disk
space without performing a VACCUM FULL? It locks the database for several
hours, and that is not a solution.
I guess a backup-restore would do the work but, isn't there a better way to
do this without shutting down po
Thanks Martijn:
It worked. I was having issues with 7.4.2, run memory ans disk checks
and hardware seems ok, that's why I decided to upgrade to 7.4.5, but
unfortunately I'm still experiencing data corruption.
Ruben.
ruben20 wrote:
-- Forwarded Message ---
From: Martijn van Ooste
