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
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
On Friday 09 January 2009 20:00:57 Tom Lane wrote:
> Reg Me Please 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'::t
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)
> >
Reg Me Please 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 i_T1_partial on T1 (cos
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 row
Could you provide the output of EXPLAIN ANALYZE with your query?
On Fri, Jan 9, 2009 at 7:06 PM, Reg Me Please 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:
>
> T1: multi-mill
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
Sorry about the typo in the subject line.
On Fri, Jan 9, 2009 at 9:05 AM, Richard Broersma
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: http://scale7x.socallinuxexpo.org
>
>
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 and
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 :
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
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
On Fri, Jan 9, 2009 at 2:31 PM, Bruce Momjian 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.
It s
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 http://momjian.us
EnterpriseDB
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.
Ch
2009/1/8 Filip Rembiałkowski :
>
>
> 2009/1/8 Joshua D. Drake
>>
>> 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
Ora-link
>
> In the op
On Fri, Jan 9, 2009 at 4:17 PM, Yogvinder Singh 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 fixes. If you are wi
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
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 copy
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)
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: Re:
On Fri, Jan 9, 2009 at 2:53 PM, Yogvinder Singh 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 operations
which lea
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
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 pgsql-gene
26 matches
Mail list logo
