Hi,
is there any chance to get the "Planner Cost Constants" right enough to get a
"good" estimate in seconds of how long a query is supposed to run?
The "rowcount" estimates are always good (there is no skew data at all in the
db, values are pretty much "plain" distributed)
--
Sent via p
Tom Lane wrote:
Ron Mayer writes:
Sam Mason wrote:
You get an error because " 123 11" isn't a valid literal of an
(undecorated) INTERVAL type.
Hmm. should it be?
Well, we do allow it if it's *explicitly* stated to be a day to hour
interval:
regression=# select interval '123 11' day t
Hello list,I will try to make this as brief as possible.
I have a brother who is a scientist studding atmospheric problems. He was
trying to handle all of his data with flat files and MatLab, when I stepped
in and said, wait, you need a RDBMS to handle all this data.
So, he basically has 2 very s
Try partitioning. It should sort you out.
-Peter-
On 5/25/09, Ramiro Diaz Trepat wrote:
>
> Hello list,I will try to make this as brief as possible.
> I have a brother who is a scientist studding atmospheric problems. He was
> trying to handle all of his data with flat files and MatLab, when I
You might want to try CREATE CLUSTER. I had a 40M row table that was
taking ages to access, I tried partitioning it into 12000 sub-tables,
and obtained a modest speed up. Using CREATE CLUSTER on an
un-partitioned table resulted in an enormous speed up though.
You will need to choose the axis you w
Hello,
I'd try to use postgis ( http://postgis.refractions.net ), that allows
you to geolocalize your data. We use such an extention here for the
same kind of data you use. It will lighten up table size, and queries.
Otherwise, partitioning and cluster are good things to do. I would
increase defau
On May 25, 2009, at 4:56 AM, marco santillan wrote:
Hola a todos:
Tengo la siguiente inquietud. En una consulta com la siguiente:
select campo1,
campo2,
campo1 - campo2 as campo_virtual,
campo3,
case when campo_virtual = 1 then 5 else 0 end as segundo_campo_virtual
from tabla;
Esto lo puedo h
On May 25, 2009, at 10:58 AM, Ramiro Diaz Trepat wrote:
The table with the atmosphere pixels, currently has about 140MM
records, and the one the values about 1000MM records. They should
both grow to about twice this size.
Did you tune postgres to use the available resources? By default it
O podrías escribir,
select campo1,
campo2,
campo1 - campo2 as campo_virtual,
campo3,
case when campo1 - campo2 = 1 then 5 else 0 end as segundo_campo_virtual
from tabla;
Saludos.
R.
On May 25, 2009 6:18am, Alban Hertroys
wrote:
On May 25, 2009, at 4:56 AM, marco santillan wrote:
Hola
Hi Everyone,
I need to build a simple gui front end with jdbc access to my Postgres
database. I have the front end ready and I have some code which retrieves
records from my database, but for some reason I keep on getting errors
(lately just freezes without errors) when I apply that same code to
APseudoUtopia wrote:
2. I do not want to get rid of any comments, even if the user is
deleted (on the application level, I'd display something like
UnknownUser or UnknownUser#1234). Right now, I just have it ON DELETE
RESTRICT, but that obviously prevents any users who have commented
from being d
Craig Ringer writes:
> The locking docs:
> http://www.postgresql.org/docs/8.3/static/explicit-locking.html
> don't say anything about which lock DROP INDEX takes on a relation. A
> quick test shows it takes an AccessExclusiveLock on the affected index,
> and appears to take no lock at all on the t
- Original Message -
From: "Lew"
To:
Sent: Saturday, May 23, 2009 2:18 PM
Subject: Re: [GENERAL] Daylight saving time question
Bayless Kirtley wrote:
Thanks Tom and Scott. You got me looking in the right direction. In this
case
the client and server are on the same machine (testin
Dear List
I have a csv file that I would like to import into Postgresql, the
structure of the csv file is in this format:
"field1","field2","field3","field4"
"1","2","RD","1"
"2","2","RD","1"
"4","2","RD","1"
"4","2","RD","1"
"5","2","RD","1"
"5","2","RD","1"
"5","2","RD","
what's the postgrtesql version there ?
(just do "select version();", or psql --version);
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
Greetings,
* Intengu Technologies (sindile.bi...@gmail.com) wrote:
> What I would like to do is
>
> If field1=1 make table1 and insert the rest of field1=1 into this table
> If field1=2 make table2 and insert the rest of field1=2 into this table
>
> Hence in this example one will have table1, ta
On Mon, May 25, 2009 at 4:12 PM, Stephen Frost wrote:
> This currently can't be done with the COPY command directly. There are
I would put it in postgresql as is, and than do "CREATE TABLE foo AS
SELECT CASE ... END ;"
--
GJ
--
Sent via pgsql-general mailing list (pgsql-general@postgr
On Mon, May 25, 2009 at 12:10:21AM -0700, Scara Maccai wrote:
> is there any chance to get the "Planner Cost Constants" right enough to get a
> "good" estimate in seconds of how long a query is supposed to run?
> The "rowcount" estimates are always good (there is no skew data at all in the
> db,
* Grzegorz Jaśkiewicz (gryz...@gmail.com) wrote:
> On Mon, May 25, 2009 at 4:12 PM, Stephen Frost wrote:
>
> > This currently can't be done with the COPY command directly. There are
> I would put it in postgresql as is, and than do "CREATE TABLE foo AS
> SELECT CASE ... END ;"
Right, that
2009/5/25 Stephen Frost :
>
> Right, that would be option #3 from my list. :)
Aye,
The reason I am asking about version, is because 8.1 can't import CSV
using COPY.
--
GJ
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.pos
Why is it not possible to create domain on composite type ?
Consider the example, I got (a bytea, b timestamp, c timestamp). Where
b < c always, and both b and c have some default value, a can stay
null.
Now, I don't want to go berserk, and create aditional table for that,
because type is shared b
OK,
So I gave up on the universal binary, and just built a PPC version of
postgres. If I execute the command:
SELECT usename FROM pg_catalog.pg_user;
from within psql, I get:
usename
-
esmith
radiovision
(2 rows)
Seems to work just fine. If, on the other hand, I issue t
Eric Smith writes:
> Seems to work just fine. If, on the other hand, I issue the same
> command from within the C API:
> NSString* query = [NSString stringWithFormat:@"SELECT usename FROM
> pg_catalog.pg_user"];
> postgresResult = PQexec(myConnection, [query UTF8String]);
> I get an e
Alrighty so, how do I turn on log_statement?
Thanks,
Eric
On May 25, 2009, at 5:31 PM, Tom Lane wrote:
Eric Smith writes:
Seems to work just fine. If, on the other hand, I issue the same
command from within the C API:
NSString* query = [NSString stringWithFormat:@"SELECT usename FROM
Very interesting.
when I set log_statement='all', I see entries for various queries, but
I see nothing for the query I list below. If I just use printf() to
print out the c-string, it looks just like all the other queries.
Eric
On May 25, 2009, at 5:31 PM, Tom Lane wrote:
Eric Smith wr
OK... never mind, everyone. The problem was elsewhere in the code.
Regards,
Eric
On May 25, 2009, at 5:31 PM, Tom Lane wrote:
Eric Smith writes:
Seems to work just fine. If, on the other hand, I issue the same
command from within the C API:
NSString* query = [NSString stringWithFormat:@
Tom Lane wrote:
> Craig Ringer writes:
> Not sure how you tested that, but index_drop() clearly takes
> AccessExclusiveLock on the table too. (I'm not sure it really needs
> to --- the comment therein defending the reasoning seems out of date
> --- but it definitely does.)
I just re-checked, an
queries wrote:
> Hi Everyone,
>
> I need to build a simple gui front end with jdbc access to my Postgres
> database. I have the front end ready and I have some code which retrieves
> records from my database, but for some reason I keep on getting errors
> (lately just freezes without errors) when
I had the same problem as OP.
With Windows 7 x64 & postgresql Version 8.3.7-1
It seems like running tuning wizard changes the permissions of the
postgres.conf file so that the .postgres account is not able to read it.
Similar to OP's situation, postgres was working fine until ran the tuning
wiz
I have a table of about 1 G rows, and I want to delete about 5 M rows,
listed in another table.
The big table is
Table "public.backlinks"
Column | Type | Modifiers | Description
-+---+---+-
key | bytea | not null |
back
Version 8.3.7
On 25/05/2009, Grzegorz Jaśkiewicz wrote:
> what's the postgrtesql version there ?
> (just do "select version();", or psql --version);
>
--
Sindile Bidla
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postg
Thanks for the pointers will try them.
On 25/05/2009, Stephen Frost wrote:
> Greetings,
>
> * Intengu Technologies (sindile.bi...@gmail.com) wrote:
>> What I would like to do is
>>
>> If field1=1 make table1 and insert the rest of field1=1 into this table
>> If field1=2 make table2 and insert the
On Mon, May 25, 2009 at 1:29 PM, mARK bLOORE wrote:
> The table listing what I want to delete has just the key values.
>
> If I just do
>
> DELETE FROM backlinks b USING bad_links bl WHERE b.key = bl.key;
>
> then it grinds for an hour or so and runs out of memory.
>
> If I do
>
> DELETE FROM back
Hi Craig,
Thank you for your reply and for all of the pointers. I didn't include the
Gui code (It would have taken too much space), just the simple query code
that already works in printing out the results I wanted. Basically I just
wanted to find out how to use this code which works, inside of a
34 matches
Mail list logo
