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 a
"Shane Wright" 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 achieve, so far I've tried
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 a
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
Adrian Klaver wrote:
> On Sunday 21 December 2008 1:49:18 am Herouth Maoz wrote:
>
>> Adrian Klaver wrote:
>>
>>>
>>>
>>> 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
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
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 work i can't
> acces
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
---
008925700
On Tue, Dec 23, 2008 at 9:05 AM, wrote:
> TABLENAME
>
> id Candidate pattern
> -
> 1 0089258068520
> 2 008925806852
> 3 00892580685
> 4 0089258068
> 5 008925806
> 6 00892580
> 7 0089258
> 8 008925
> 9 00892
> 10
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
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
dimitris.sakellar.
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 :
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 change
Jef thanks alot for your help.
I appreciate that!
It worked fine.
Dimitris
Quoting "Hoover, Jeffrey" :
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:
http://www
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
On
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 to
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 78B
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
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
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
f
- "justin" 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
> statement?
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
> som
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 can'
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 co
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 su
Adrian Klaver wrote:
- "justin" 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
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 no
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 Po
33 matches
Mail list logo
