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
???
In the future please don't cross post to multiple lists.
Message from raghavendra t
raagavendra@gmail.comraagavendra@gmail.comat 04-03-2010 10:08:11
PM --
step 6 - Issue the commit in Session A
postgres=# commit;
Step -7 now we can the see the error in the session B
ERROR
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
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
the performance question..
Regards
Raghavendra
On Thu, Apr 1, 2010 at 2:32 AM, Kevin Grittner
kevin.gritt...@wicourts.govwrote:
raghavendra t raagavendra@gmail.com wrote:
I have a table with 40GB size, it has few indexes on it.
What does the table look like? What indexes are there?
When i try
. 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
kevin.gritt...@wicourts.govwrote:
raghavendra t raagavendra@gmail.com wrote:
overcome
Thank you for the suggestion.
On Thu, Apr 1, 2010 at 3:21 AM, Kevin Grittner
kevin.gritt...@wicourts.govwrote:
raghavendra t raagavendra@gmail.com 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
:
raghavendra t raagavendra@gmail.com wrote:
Thank you for the suggestion.
I'm sorry I couldn't come up with more, but what you've provided so
far is roughly equivalent to me telling you that it takes over four
hours to travel to see my Uncle Jim, and then asking you how I can
find out how
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 matt...@flymine.orgwrote:
On Mon, 29 Mar 2010, Tadipathri Raghu wrote:
As per the