Tom,
You need to
look into what the estimated vs actual rowcounts are for just the
two-column condition (ie, where nid = something AND iid1 = something).
Getting those estimates to match reality is the key to getting a sane
plan choice here.
Many thanks - I agree in principle it isn't
Shane Wright shane.wri...@edigitalresearch.com writes:
Tom,
You need to
look into what the estimated vs actual rowcounts are for just the
two-column condition (ie, where nid = something AND iid1 = something).
Improving the accuracy of the cost estimates is exactly what I'm trying
to
Hi Tom,
- increasing the statistics target to the maximum setting with SET
STATISTICS 1000 on columns rid, nid and iid1 of answers, then
re-vacuuming.
I hope you meant re-analyzing.
Hehe absolutely yes; I always VACUUM VERBOSE ANALYSE :)
Index Scan using index_answers_nidiid1 on answers
Tom,
Index Scan using index_answers_nidiid1 on answers
(cost=0.00..114.14 rows=1 width=60) (actual time=0.206..2398.645
rows=21891 loops=1)
Index Cond: ((nid = 253869913) AND (iid1 = 535292129))
Total runtime: 2424.769 ms
Well, here's the problem all right: 1 row estimated vs 21891
Adrian Klaver wrote:
On Sunday 21 December 2008 1:49:18 am Herouth Maoz wrote:
Adrian Klaver wrote:
Snip
Are you sure the problem is not in $datefield = * . That the script
that formats the data file is not correctly adding * to the right file.
Seems almost like sometimes the
Hi !
There isn't another way to download 8.4devel that isn't
cvs and the last rpm binary?
I mean, i need source code, but in my work i can't
access with cvs because proxy policies.
Sorry for my bad english,
--
Emanuel Calvo Franco
Syscope Postgresql Consultant
ArPUG / AOSUG Member
ftp://ftp.postgresql.org/pub/snapshot/dev/
I think that's the right place.
On Tue, Dec 23, 2008 at 9:09 AM, Emanuel Calvo Franco
postgres@gmail.com wrote:
Hi !
There isn't another way to download 8.4devel that isn't
cvs and the last rpm binary?
I mean, i need source code, but in my
On Tuesday 23 December 2008 6:43:56 am Herouth Maoz wrote:
Well, every time this happens, I re-run the procedure, with all the
lines in the data files up to the given table deleted. And it works.
Then I restore the original data file. And the next day it works. It
only happens once in a
TABLENAME
id Candidate pattern
-
1 0089258068520
2 008925806852
3 00892580685
4 0089258068
5 008925806
6 00892580
7 0089258
8 008925
9 00892
10 0089
11 008
12 00
13 0
PATTERN
---
On Tue, Dec 23, 2008 at 9:05 AM, dimitris.sakellar...@telesuite.gr wrote:
TABLENAME
id Candidate pattern
-
1 0089258068520
2 008925806852
3 00892580685
4 0089258068
5 008925806
6 00892580
7 0089258
8 008925
I should say I'd pad them to match length with the input value.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
dimitris.sakellar...@telesuite.gr wrote:
TABLENAME
idCandidate pattern
-
10089258068520
2008925806852
300892580685
40089258068
5008925806
600892580
70089258
8008925
900892
100089
11008
1200
130
Hi, Dimitris
I think simple
SELECT TABLENAME.id
FROM TABLENAME
WHERE prm_patern ilike TABLENAME.candidate_pattern||'%'
ORDER BY |char_length(|TABLENAME.candidate_pattern) desc
LIMIT 1
should do the trick. (Provided TABLENAME is not very large of course)
Julius Tuskenis
SELECT ... from . WHERE X LIKE pattern || '%' ORDER BY
length(pattern) DESC LIMIT 1;
???
basic prefix matching for telcos :P
--
GJ
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
thanks alot for your help.
Dimitris
Quoting Grzegorz Jaśkiewicz gryz...@gmail.com:
SELECT ... from . WHERE X LIKE pattern || '%' ORDER BY
length(pattern) DESC LIMIT 1;
???
basic prefix matching for telcos :P
--
GJ
--
Sent via pgsql-general mailing list
Jef thanks alot for your help.
I appreciate that!
It worked fine.
Dimitris
Quoting Hoover, Jeffrey jhoo...@jcvi.org:
cameradb_dev=# select id, Candidate_pattern
from all_patterns
where :pattern like Candidate_pattern||'%'
and candidate_pattern between substring(:pattern from 1 for 1) and
On Tue, Dec 23, 2008 at 06:05:08PM +0200, dimitris.sakellar...@telesuite.gr
wrote:
QUESTION
Pls let me know which is the best way to match the
following pattern against this table and Receive id = 8
that is the longest matching pattern from left to right.
check this:
Thanks depesz,
It was really helpful
Dimitris.
-Original Message-
From: dep...@depesz.com [mailto:dep...@depesz.com]
Sent: Tuesday, December 23, 2008 9:18 PM
To: dimitris.sakellar...@telesuite.gr
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] Question about pattern matching
have a function written in pgsql it runs just fine, except its doing
something really stupid.
The function runs just fine till this select statement
Select (wo_wipvalue/wo_qtyord)
into _TotalCost
from wo
where wo_id = pWoid ;
This goes to the work order header table
Hi all !
How can I programmatically detect which encoding a
PostgreSQL server I am trying to connect to sends back
messages -- before I connect (so client_encoding and
the pg_settings table are flat out).
Thanks,
Karsten
--
GPG key ID E4071346 @ wwwkeys.pgp.net
E167 67FD A291 2BEA 73BD 4537
Karsten Hilbert wrote:
Hi all !
How can I programmatically detect which encoding a
PostgreSQL server I am trying to connect to sends back
messages -- before I connect (so client_encoding and
the pg_settings table are flat out).
Hmm, isn't client_encoding reported in the startup packet sent
On Tue, Dec 23, 2008 at 06:45:17PM -0300, Alvaro Herrera wrote:
How can I programmatically detect which encoding a
PostgreSQL server I am trying to connect to sends back
messages -- before I connect (so client_encoding and
the pg_settings table are flat out).
Hmm, isn't client_encoding
On Tuesday 23 December 2008 1:04:49 pm justin wrote:
have a function written in pgsql it runs just fine, except its doing
something really stupid.
The function runs just fine till this select statement
Select (wo_wipvalue/wo_qtyord)
into _TotalCost
from wo
Adrian Klaver wrote:
On Tuesday 23 December 2008 1:04:49 pm justin wrote:
have a function written in pgsql it runs just fine, except its doing
something really stupid.
The function runs just fine till this select statement
Select (wo_wipvalue/wo_qtyord)
into _TotalCost
- justin jus...@emproshunts.com wrote:
Adrian Klaver wrote:
Would help to see the
whole function. Also make sure you did not name one of
the variables the same as a column name, this will confuse plpgsql.
Are you
using the same value for wo_id in the function as in the manual select
On Tuesday 23 December 2008 3:36:46 pm Adrian Klaver wrote:
Hmmm. A couple of suggestions while I ponder this more. For clarity sake
decide on a case scheme. I start getting twitchy when I see pwoid and pWoid
refer to the same thing. This depends on case folding being consistent, not
On Dec 23, 2008, at 4:24 PM, Karsten Hilbert wrote:
How can I programmatically detect which encoding a
PostgreSQL server I am trying to connect to sends back
messages -- before I connect (so client_encoding and
the pg_settings table are flat out).
I don't think there is a way because you
Adrian Klaver wrote:
On Tuesday 23 December 2008 3:36:46 pm Adrian Klaver wrote:
Hmmm. A couple of suggestions while I ponder this more. For clarity sake
decide on a case scheme. I start getting twitchy when I see pwoid and pWoid
refer to the same thing. This depends on case folding being
Hello Peeps,
I'd like to take this opportunity to wish you nice helpful bunch my
warm greetings. Hope you have a fantastic time and looking forward to
learn more in the new future.
Novice tgurl ;-)
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your
Adrian Klaver wrote:
- justin jus...@emproshunts.com wrote:
Adrian Klaver wrote:
Would help to see the
whole function. Also make sure you did not name one of
the variables the same as a column name, this will confuse plpgsql.
Are you
using the same value for wo_id in the function as
Dear All,
I using PosgreSql8.1.I want to import Excel into PostgreSQL database. Is
there any way to import ? .
Please anyone can guide me.
I am waiting for your great response.
Thanks
Venkat.
Venkat Rao Tammineni escribió:
Dear All,
I using PosgreSql8.1.I want to import Excel into PostgreSQL
database. Is there any way to import ? .
Please anyone can guide me.
I am waiting for your great response.
Thanks
Venkat.
Try with csv format and think it's going a
Hi,
Thanks a lot.
Regards
Venkat.
-Original Message-
From: Julio Cesar Sánchez González
[mailto:know...@sistemasyconectividad.com.mx]
Sent: Wednesday, December 24, 2008 1:14 PM
To: Venkat Rao Tammineni
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] How to Import Excel Into
33 matches
Mail list logo