;
> On Sun, Oct 21, 2012 at 5:46 AM, Chitra Creta wrote:
>
>> Thank you all.
>>
>> Ryan, would you mind sharing your one-time function to move it?
>>
>> Merlin, what are your suggestions to improve query performance?
>>
>> Shaun, thank you. I will
Travers wrote:
>
>
> On Fri, Oct 12, 2012 at 7:44 AM, Chitra Creta wrote:
>
>> Hi,
>>
>> I currently have a table that is growing very quickly - i.e 7 million
>> records in 5 days. This table acts as a placeholder for statistics, and
>> hence the records are me
Explain Analyse allow me to determine whether
querying the parent table for statistics is quicker than querying against a
massive non-partitioned table?
Thank you.
On Oct 13, 2012 3:49 AM, "John R Pierce" wrote:
> On 10/12/12 7:44 AM, Chitra Creta wrote:
>
>>
>> 1.
Hi,
I currently have a table that is growing very quickly - i.e 7 million
records in 5 days. This table acts as a placeholder for statistics, and
hence the records are merely inserted and never updated or deleted.
Many queries are run on this table to obtain trend analysis. However, these
queries
Hello all,
Any thoughts on this one?
Cheers.
On Tue, May 1, 2012 at 9:51 PM, Chitra Creta wrote:
> Hi there,
>
> I have mission-critical data running on PostgreSQL 8.3. My database got
> corrupted a few days ago as I ran out of disk space.
>
> I had to run pg_resetxlog t
Hi there,
I have mission-critical data running on PostgreSQL 8.3. My database got
corrupted a few days ago as I ran out of disk space.
I had to run pg_resetxlog to get the database started again. I am now
experiencing the following errors:
1. ERROR: t_xmin is uncommitted in tuple to be updated
Hello all,
I am interested in knowing how to upgrade a database structure on an
existing database.
I have a script that creates and alters tables, columns and data. When this
script is run, errors are thrown for already inserted tables, columns and
data. Anything that is not found in the exis
