Anyone got any insight or experience in the speed and size of indexes on
Integer(4 byte) vs float (8byte). For a project that I'm on, I'm contemplating
using an integer for:
Latitude
Longitude
In a huge, publically searchable table.
In the INSERTS, the representation would be equal
Tom Lane wrote:
Dirk Riehle writes:
For one analysis, I created a table of about 15 columns, and then ran an
insert with a subselect on the table, where the select was drawing from
three other tables, merging over ids. One of the other tables has about
60M rows.
The insert ran for about 18h
Scott Marlowe wrote:
So, I wonder what went wrong? Any explanation? Soft raid no good for
PostgreSQL?
I've no such problems caused by modern linux software RAID (md). It's
no surprise pgsql didn't free up the space, as it was all likely dead
tuples at that point. Are you sure you didn't hav
Depending on the details, I'd love to attend. Any more specifics, by chance?
On 7/11/09, Richard Broersma wrote:
> Josh Berkus and David Fetter will be in West Los Angeles area the
> beginning of next week. This would be a good opportunity to get
> together to enjoy dinner and drinks with Postg
Dirk Riehle writes:
> For one analysis, I created a table of about 15 columns, and then ran an
> insert with a subselect on the table, where the select was drawing from
> three other tables, merging over ids. One of the other tables has about
> 60M rows.
> The insert ran for about 18h before r
On Sat, Jul 11, 2009 at 4:41 PM, Dirk Riehle wrote:
> Hi,
>
> I had some weird disk space consumption problem. I do (non-mission-critical)
> data crunching using large data sets.
>
> For one analysis, I created a table of about 15 columns, and then ran an
> insert with a subselect on the table, whe
Hi,
I had some weird disk space consumption problem. I do
(non-mission-critical) data crunching using large data sets.
For one analysis, I created a table of about 15 columns, and then ran an
insert with a subselect on the table, where the select was drawing from
three other tables, merging
Dennis Gearon
Signature Warning
EARTH has a Right To Life
I agree with Bolivian President Evo Morales
# The right to life: "The right for no ecosystem to be eliminated by the
irresponsible acts of human beings."
# The right of biosystems to regenerate themselves: "Developmen
Doh! That's it. Thanks a million.
-- Roy
Tom Lane wrote:
Roy Walter writes:
This one does not:
INSERT INTO wms_collection (docxml) VALUES (XMLPARSE(content(
'
]>
Shoes
')))
What I know about XML wouldn't fill a thimble, but shouldn't you
Josh Berkus and David Fetter will be in West Los Angeles area the
beginning of next week. This would be a good opportunity to get
together to enjoy dinner and drinks with PostgreSQL's community
leaders.
Please reply to the LAPUG mailing list if you would like to attend.
--
Regards,
Richard Bro
Kiwis,
I'd like to have a PostgreSQL miniconf at LinuxConf.AU in 2010.
Deadline to apply is July 17.
I know we have an NZ community ... can you get in touch so we could put
together a proposal?
--
Josh Berkus
PostgreSQL Experts Inc.
www.pgexperts.com
--
Sent via pgsql-general mailing list
Roy Walter writes:
> This one does not:
> INSERT INTO wms_collection (docxml) VALUES (XMLPARSE(content(
> '
> [
>
>
> ]>
>
> Shoes
> ')))
What I know about XML wouldn't fill a thimble, but shouldn't you say
DOCUMENT not CONTENT if you are trying to pro
On Fri, Jul 10, 2009 at 08:40:28PM -0400, Scot Kreienkamp wrote:
> Anyway, I'm trying to attack it from the database side out since I am
> not a programmer and can't help with that part. I can do simple CGIs
> with bash, but I don't know Java or C or even Perl yet for that matter.
> Since you guys
Peter-
if by 'dangerous' you mean employable then count me in!
Oracle is probably the only DB vendor which implements Clinical Informatics
product
would like to hear about any Clinical Informatics offerings postgres would offer
I'm thinking a relational tree might work something like
Gene ->1..n
On 10/07/2009 21:56, Jorge Arangoitia Fernandez Baca wrote:
> I want to know if you can create a store procedure that run
> automatically after a certain time, something like a timer in java. If
> it exists, could you tell me how it is implemented??
Put your function in a file, and then create a
Hey guys,
I'm learning Postgresql and trying to inserts only new entries in a table and
skips duplicates. I know this is a recurrent question, but maybe you could
point out what I'm doing wrong in this specific case.
Initially, I have two tables: from_t and to_t (empty);
mydb=> select * from
Hi
I want to know if you can create a store procedure that run
automatically after a certain time, something like a timer in java. If
it exists, could you tell me how it is implemented??
Thanks
On Jul 9, 2:18 pm, t...@sss.pgh.pa.us (Tom Lane) wrote:
> Niederland writes:
> > SQL 2: select ('A' || '\r\n' || 'B') as tt from customer limit 1
> > Functions without escaping literal
>
> Really? I get
>
> regression=# select ('A' || '\r\n' || 'B') as tt from customer limit 1;
> WARNING: nonsta
On Jul 10, 2009, at 7:38 PM, James B. Byrne wrote:
I have a situation with a Rails project where test data in
mysteriously "disappearing" in the middle of a test run. I would
like to see the exact SQL of all client requests issued against a
single table during a fixed time span.
Are you sure
On Jul 10, 2009, at 3:00 PM, Andre Lopes wrote:
Hi,
I will be developing a WorkFlow Application, but I don't know the
best practices on how to design a WorkFlow on a Database.
Can you give me some clues? Books, links on the Internet, etc...
It depends on how far you want to take that.
F
It's not an xpath problem it's an XML import problem. Sorry if I wasn't
clear.
Consider the following example queries. This one works fine:
INSERT INTO wms_collection (docxml) VALUES (XMLPARSE(content(
'
Shoes
')))
This one does not:
INSERT INTO wms_collection (docxml) VALU
I have an application that I am working on that may do some regular, cron
generated time date conversions.
It would do:
DATE + TIME = TIMESTAMP.
It would do a LOT of thesebut spread out over every day to keep the load down
and allow the server to do it's may job, dish out the results.
Wh
22 matches
Mail list logo
