an't
> find the table???
>
> In the future please don't cross post to multiple lists.
>
> Message from raghavendra t
> at 04-03-2010 10:08:11
> PM --
>
>
> step 6 - Issue the commit in Session A
>
> postgres=# commit;
>
> Step -7 now
Hi All,
I am facing the error "cache lookup failed for relation X" in Postgres-8.4.2
version. As you all know, its a reproducable and below is the example.
This can be generated with two sessions;
Am opening two sessions here Session A and Session B
Session A
=
step 1 - creating the table
Hi All,
System Config
-
CPU - Intel® Xenon® CPU
CPU Speed - 3.16 GHz
Server Model - Sun Fire X4150
RAM-Size - 16GB
> Steve:
So am I to understand I don't need to do daily reindexing as a maintenance
> measure with 8.3.7 on FreeBSD.
My question is something like Steve's, why
ed to keep a discussion to the point
mentioned. Truely this question belong to some other place as you have
mentioned in the URL. But answer for Q1 might be expected alteast. Hope i
could get the information from the other Thread in other catagory.
Thank you
Regards
Raghavendra
On Thu, Apr 1,
Thank you for the suggestion.
On Thu, Apr 1, 2010 at 3:21 AM, Kevin Grittner
wrote:
> raghavendra t wrote:
>
> > my question is, how to get a performance on the existing indexes.
> > You mean to say , drop the existing indexes and create the index
> > with CONCURRE
on the existing indexes. You
mean to say , drop the existing indexes and create the index with
CONCURRENTLY. Does this give the performance back.
Regards
Raghavendra
On Thu, Apr 1, 2010 at 3:10 AM, Kevin Grittner
wrote:
> raghavendra t wrote:
>
> > overcome with a corrupted index.
&g
postgresql.org/wiki/SlowQueryQuestions
Expected the performance question..
Regards
Raghavendra
On Thu, Apr 1, 2010 at 2:32 AM, Kevin Grittner
wrote:
> raghavendra t wrote:
>
> > I have a table with 40GB size, it has few indexes on it.
>
> What does the table look like? What ind
Hi All,
I have a table with 40GB size, it has few indexes on it. When i try to
REINDEX on the table, its take a long time. I tried increasing the
maintenance_work_mem, but still i havnt find a satisfying result.
Questions
===
1. What are the parameters will effect, when issuing the REINDEX co
Hi Mattew,
Thank you for the information.
Once again, I like to thank each and everyone in this thread for there
ultimate support.
Regards
Raghavendra
On Mon, Mar 29, 2010 at 4:47 PM, Matthew Wakeling wrote:
> On Mon, 29 Mar 2010, Tadipathri Raghu wrote:
>
>> As per the documentation, one page
