exists() version ? Is it true to say that the exists()
version is more scalable (with many rows) than the in() version (from
the little tests I made it seems the case) ?
Thanks,
Julien
--
Julien Cigar
Belgian Biodiversity Platform
http://www.biodiversity.be
Université Libre de Bruxelles (ULB)
C
".specimen_id)
so I guess that :
select count(sp.id) from specimens sp where sp.id in (select specimen_id
from sequences);
is almost the same as :
select count(sp.id) from specimens sp INNER JOIN (select specimen_id
from sequences GROUP BY specimen_id) as foo on foo.specimen_id = sp.id;
?
ds coming from specimens of course)
Julien
On Thu, 2008-03-13 at 15:12 +0100, Bart Degryse wrote:
> I think that just
> select count(sp.id) from specimens sp INNER JOIN sequences s on
> s.specimen_id = sp.id;
> should be enough
>
> >>> Julien <[EMAIL PROTECTED]> 2008-0
easurements GROUP BY specimen_id) as foo on
foo.specimen_id = sp.id;
count
---
75241
(1 row)
Time: 1165.487 ms
Regards,
Julien
On Thu, 2008-03-13 at 15:28 +0100, Bart Degryse wrote:
> how about
> select count(distinct s.specimen_id) from specimens sp INNER JOIN
> sequences
Unless you've good reasons to do so it's best to store the file on the
file system and the file name/path in the database ...
On 05/18/2011 22:20, Emi Lu wrote:
Hello,
To save pdf files into postgresql8.3, what is the best column type?
bytea, blob, etc?
Thank you,
Emi
<>
--
Sent via pgsq
On 05/18/2011 23:00, Karsten Hilbert wrote:
On Wed, May 18, 2011 at 10:46:23PM +0200, Julien Cigar wrote:
Unless you've good reasons to do so it's best to store the file on
the file system
Why ?
If you suggest reasons are needed for storing the PDF in the
database I'd l
On 05/18/2011 23:27, Karsten Hilbert wrote:
On Wed, May 18, 2011 at 11:21:43PM +0200, Julien Cigar wrote:
Unless you've good reasons to do so it's best to store the file on
the file system
Why ?
If you suggest reasons are needed for storing the PDF in the
database I'd l
are better ways to
do it? Is it scalable?
(The final idea is to put that in a trigger, so that it will be executed
only when a new row is added, or when the row is moved from a container
to another one ..)
Thanks,
Julien
--
No trees were killed in the creation of this message.
However, m
mmh I made a little mistake: it was {A,B} of course, not {A,B,C}
On 08/23/2011 12:03, Julien Cigar wrote:
given D I want {A,B,C}
--
No trees were killed in the creation of this message.
However, many electrons were terribly inconvenienced.
<>
--
Sent via pgsql-sql mailing list (pgs
create table foo as select * from bar;
just add "where 1=2" if you just want the schema
On 08/25/2011 11:44, pp...@sapo.pt wrote:
Hello to all,
Can anybody tell me the sql instruction to create a new table with a
select of other table?
I need to create a new table based on paralell of a ta
use a regex ?
On 08/30/2011 16:51, Emi Lu wrote:
Good morning,
Does psql provide something like the following query command?
select * from tablename
where col1 not ilike ('str1%', 'str2%'... 'strN%')
Thanks a lot!
Emi
--
No trees were killed in the creation of this message.
However, many
Try to raise work_mem
On 12/07/2011 15:34, Raj Mathur (राज माथुर) wrote:
Hi,
I'm trying to correlate Call Data Records (CDRs) from two Asterisk
servers, one of which uses the other for telephony. The data is in
the tables cdr and cdr2. With some indexes, the query and explain
result are:
exp
On 12/07/2011 16:14, Raj Mathur (राज माथुर) wrote:
On Wednesday 07 Dec 2011, Julien Cigar wrote:
Try to raise work_mem
Odd, I tried adding work_mem=50MB / 256MB / 1024MB into postgres.conf
and the times actually went up to over 12 seconds. Leaving it commented
results in the 4-second time
On Tue, Mar 6, 2012 at 7:22 AM, Piyush Lenka wrote:
> Hi,
>
> I m trying to take backup of data of a particular table using pg_dump.
> I used double quotes for table name but output is :
> pg_dump : no tables were found.
>
> Command used :
> -h localhost -p 5432 -U postgres -W -F p -a -t '"TestTa
g and
enable_hashjoin to false
I'm currently out of idea why PostgreSQL still chooses a bad plan for
this query ... any hint :) ?
Thank you,
Julien
--
No trees were killed in the creation of this message.
However, many electrons were terribly inconvenienced.
<>
--
Sent v
FROM
rab.ancestors
WHERE
ancestors.subphylum_id = 18830
) GROUP BY geo_id
) as t_geo
JOIN
hit.geo_candidates gc ON gc.id = t_geo.geo_id;
Thank you,
Julien
On 04/05/2012 14:03, Mario Dankoor wrote:
Julien,
It looks like you forgot to post the query.
Mario
On
Hi Mario,
Setting it to > -1, or even removing the condition doesn't change
anything .. the problem is more that the estimate of the join point
sucks pretty much ..
Julien
On 04/05/2012 14:32, Mario Dankoor wrote:
Julien,
I generally try avoid NOT predicates.
If your geo_id is an
FYI, raising cpu_tuple_cost from 0.01 to 0.5 fixed the problem..!
On 04/05/2012 14:43, Julien Cigar wrote:
Hi Mario,
Setting it to > -1, or even removing the condition doesn't change
anything .. the problem is more that the estimate of the join point
sucks pretty much ..
Julien
On 02/18/2013 15:39, Bert wrote:
Hello,
Thanks the nice people on irc my problem is fixed.
I changed the following settings in the postgres.conf file:
default_statistics_target = 5000 -> and I analyzed the tables after
the change of course -> now I only got 2 plans anymore, in stead of 3
defa
On 02/18/2013 16:20, Julien Cigar wrote:
On 02/18/2013 15:39, Bert wrote:
Hello,
Thanks the nice people on irc my problem is fixed.
I changed the following settings in the postgres.conf file:
default_statistics_target = 5000 -> and I analyzed the tables after
the change of course ->
The following works but no rows are returned :
select specimen_id
from specimen_test_bits
where test_bit_id = all(select id from test_bits where id in (1,2,3,4));
Any idea how I could do this ? I guess the problem is my ALL() expression ...
In advance thanks,
Julien
---(end
On Wed, 2007-11-14 at 11:56 +, Richard Huxton wrote:
> Julien Cigar wrote:
> >
> > What I would like is a query that returns all the specimen_id of
> > this table which have _all_ the given test_bit_id.
> [snip]
> > With the following I got a syntax error:
&g
I finally found a solution:
SELECT specimen_id
FROM specimen_test_bits
GROUP BY specimen_id
HAVING array_accum(test_bit_id) = '{2,3,4}';
.. but I don't think it's very "clean" ..
what do you think ?
Thanks
On Wed, 2007-11-14 at 15:50 +0100, Julien Cigar wro
Thanks :) it works as expected
Julien
On Wed, 2007-11-14 at 14:31 +0100, hubert depesz lubaczewski wrote:
> On Wed, Nov 14, 2007 at 02:39:02PM +0100, Julien Cigar wrote:
> > With the following I got a syntax error:
> > select specimen_id
> > from specimen_test_bits
> &
'(-8,25)' <@ polygon
'((-3,10),(8,18),(-3,30),(-10,20))';
ERROR: operator does not exist: point <@ polygon
HINT: No operator matches the given name and argument type(s). You may
need to add explicit type casts.
... but without success as you can see ;\
In advance thanks
uot;
thanks
On Wed, 2008-05-07 at 15:38 +0100, Richard Huxton wrote:
> Julien Cigar wrote:
> > Hello,
> >
> > I'm busy to work on an application where the user can select (with
> > precision) an area on a map (for example the contours of a lake) and I
> > h
> 3
>
> select concat_something(my_field) from my_table group by something;
> the result expected would be someting like that : 1/2/3 (with a
> separator it would be really nice)
>
> I hope that I am not asking for too much ;)
>
> Thanks to all
>
--
Julien Cigar
Belg
Also, the array_accum aggregate isn't present by default, you need to
create it with :
CREATE AGGREGATE array_accum (anyelement)
(
sfunc = array_append,
stype = anyarray,
initcond = '{}'
);
On Fri, 2008-08-22 at 18:24 +0200, Julien Cigar wrote:
> of course: http://r
of course: http://rafb.net/p/EOaYfO59.html
Julien
On Fri, 2008-08-22 at 15:58 +0200, Nacef LABIDI wrote:
> any explanations ?
>
> On Fri, Aug 22, 2008 at 6:07 PM, Julien Cigar <[EMAIL PROTECTED]>
> wrote:
> array_accum ?
>
>
> On
29 matches
Mail list logo
