well, I can confirm problems is caused by indices here as well - I do
reindex twice a month because of that. (and general performance
problems caused by large index) - maybe it is time to focus on index
re usability - since HOT is already there, autovacuum does the job
too.
--
Sent via
That I'll do but that still won't answer the question : What is the reason
for the data corruption leading to MemoryContextAlloc: invalid request
size
-Original Message-
From: Scott Marlowe [mailto:scott.marl...@gmail.com]
Sent: January 08, 2009 8:18 PM
To: Yogvinder Singh
Cc: Stefan
On Fri, Jan 9, 2009 at 2:53 PM, Yogvinder Singh yogvin...@newgen.co.in wrote:
That I'll do but that still won't answer the question : What is the reason
for the data corruption leading to MemoryContextAlloc: invalid request
size
That's because you may read the corrupt data and do further
Pavan,
What is the possible reason for the data corruption?
Regards,
Yogvinder
-Original Message-
From: Pavan Deolasee [mailto:pavan.deola...@gmail.com]
Sent: January 09, 2009 2:59 PM
To: Yogvinder Singh
Cc: Scott Marlowe; Stefan Kaltenbrunner; pgsql-general@postgresql.org
Subject:
I am looking for a mac platform installer for what I was told I
needed, pgcrypto.
Assistance finding this would be appreciated...
Steve Henry
San Diego Mac IT
http://www.sdmacit.com
760.751.4292 Office - 760.546.8863 Cell
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
On fim, 2009-01-08 at 08:39 -0500, Josh Harrison wrote:
Hi,
A basic question about the COPY command syntax
This is the syntax in the postgres manual.
COPY tablename [ ( column [, ...] ) ]
FROM { 'filename' | STDIN }
..
.
What is the difference between copying from
On Fri, Jan 9, 2009 at 4:17 PM, Yogvinder Singh yogvin...@newgen.co.in wrote:
Pavan,
What is the possible reason for the data corruption?
It could be anything from buggy hardware to bug in the code. As many
have pointed out earlier, you are running a very old release and
missing several bug
Yogvinder Singh wrote:
Pavan,
What is the possible reason for the data corruption?
Yogvinder - you haven't provided any information for people to identify
what is corrupted let alone why it is corrupted. Like I said in my reply
on the 7th - it's either hardware problems or a bug in the code.
2009/1/8 Filip Rembiałkowski plk.zu...@gmail.com:
2009/1/8 Joshua D. Drake j...@commandprompt.com
On Thu, 2009-01-08 at 15:12 -0500, Josh Harrison wrote:
Hi,
Is there any utility like (oracle's dblink etc) that can establish
connection between oracle and postgres database?
dbi-link
Hi Mohammed,
See my answers below, and hopefully they won't lead you too far astray.
Note though, it has been a long time since I have done this and there
are doubtless more knowledgeable people in this forum who will be able
to correct anything I say that may be misleading or incorrect.
Steve Henry wrote:
I am looking for a mac platform installer for what I was told I
needed, pgcrypto.
Assistance finding this would be appreciated...
It is part of /contrib. I am not sure where it is in the mac installer.
--
Bruce Momjian br...@momjian.ushttp://momjian.us
On Fri, Jan 9, 2009 at 2:31 PM, Bruce Momjian br...@momjian.us wrote:
Steve Henry wrote:
I am looking for a mac platform installer for what I was told I
needed, pgcrypto.
Assistance finding this would be appreciated...
It is part of /contrib. I am not sure where it is in the mac installer.
On Fri, 2009-01-09 at 08:17 +0100, Reg Me Please wrote:
On Friday 09 January 2009 00:10:53 Jeremiah Jahn wrote:
Just wanted to say thank you for version 8.3.
The ordered indexing has dropped some of my search times from over 30
seconds to 3. I've been beating my head against this issue
On Friday 09 January 2009 15:46:51 Jeremiah Jahn wrote:
On Fri, 2009-01-09 at 08:17 +0100, Reg Me Please wrote:
On Friday 09 January 2009 00:10:53 Jeremiah Jahn wrote:
Just wanted to say thank you for version 8.3.
The ordered indexing has dropped some of my search times from over 30
Thank you for you detailed answer. I have learned alot more about this stuff
now :)
As I see it accordingly to the results it's between Hunspell and Aspell. My
Aspell version is 0.6 released 2006. The Hunspell was released in 2008.
When I run the Postgres command \dFt I get the following list :
Thank you for you detailed answer. I have learned alot more about this stuff
now :)
As I see it accordingly to the results it's between Hunspell and Aspell. My
Aspell version is 0.6 released 2006. The Hunspell was released in 2008.
When I run the Postgres command \dFt I get the following list :
The call is going out for PostgreSQL enthusiasts. We are seeking
volunteers to assist the PostgreSQL booth for this years Southern
California Linux Expo: http://scale7x.socallinuxexpo.org
The Exhibit hall will be open on Saturday the February 21st and Sunday
the 22nd between the hours of 10am
Sorry about the typo in the subject line.
On Fri, Jan 9, 2009 at 9:05 AM, Richard Broersma
richard.broer...@gmail.com wrote:
The call is going out for PostgreSQL enthusiasts. We are seeking
volunteers to assist the PostgreSQL booth for this years Southern
California Linux Expo:
Hi.
For an INNER JOINed query, EXPLAIN says that a nested loop is responsible
for the big part of the time needed to run.
The 2 tables JOINed are:
T1: multi-million rows
T2: few dozens rows
The join is though a single column in both sides and it's NOT a PK in either
table. But I have indexes
Could you provide the output of EXPLAIN ANALYZE with your query?
On Fri, Jan 9, 2009 at 7:06 PM, Reg Me Please regmeple...@gmail.com wrote:
Hi.
For an INNER JOINed query, EXPLAIN says that a nested loop is responsible
for the big part of the time needed to run.
The 2 tables JOINed are:
Here it comes:
Aggregate (cost=227.59..227.61 rows=1 width=8)
- Nested Loop (cost=0.00..227.34 rows=49 width=8)
- Seq Scan on T2 (cost=0.00..1.07 rows=6 width=4)
Filter: (fld1 = 'VEND'::text)
- Index Scan using i_T1_partial on T1 (cost=0.00..37.61
Reg Me Please regmeple...@gmail.com writes:
Aggregate (cost=227.59..227.61 rows=1 width=8)
- Nested Loop (cost=0.00..227.34 rows=49 width=8)
- Seq Scan on T2 (cost=0.00..1.07 rows=6 width=4)
Filter: (fld1 = 'VEND'::text)
- Index Scan using
On Friday 09 January 2009 20:00:36 Thomas Pundt wrote:
Reg Me Please wrote:
Here it comes:
Aggregate (cost=227.59..227.61 rows=1 width=8)
- Nested Loop (cost=0.00..227.34 rows=49 width=8)
- Seq Scan on T2 (cost=0.00..1.07 rows=6 width=4)
Filter: (fld1
On Friday 09 January 2009 20:00:57 Tom Lane wrote:
Reg Me Please regmeple...@gmail.com writes:
Aggregate (cost=227.59..227.61 rows=1 width=8)
- Nested Loop (cost=0.00..227.34 rows=49 width=8)
- Seq Scan on T2 (cost=0.00..1.07 rows=6 width=4)
Filter: (fld1
Reg Me Please wrote:
Here it comes:
Aggregate (cost=227.59..227.61 rows=1 width=8)
- Nested Loop (cost=0.00..227.34 rows=49 width=8)
- Seq Scan on T2 (cost=0.00..1.07 rows=6 width=4)
Filter: (fld1 = 'VEND'::text)
- Index Scan using i_T1_partial on T1
I need to change some table names, substitute some with views and
duplicate others.
As a first experiment I was planning to create a view that clone a
table and then rename the occurrences of the table name with the
view where needed finally change the definition of the view.
Am I going to incur
26 matches
Mail list logo