On Thu, Mar 19, 2009 at 12:49:52AM +0100, Marco Colombo wrote:
> It has to wait for I/O completion on write(), then, it has to go to
> sleep. If two different processes do a write(), you don't know which
> will be awakened first. Preallocation don't mean much here, since with
> O_SYNC you expect a
Alvaro Herrera wrote:
> > > > This happens when I import csv file via my app into postgres.
> > > > The csv file has some “hello” from microsoft word 2003.
> > > > In postgres it appears as hello
> > > >
> > > > Could somebody help on this?
> > >
> > > Check your encodings.
> >
> > I doubt tha
Greetings
I have a record variable in plpgsql function:
DECLARE
tabRow TAB%ROWTYPE;
someVar varchar;
BEGIN
/*I Can do something like this*/
insert into TAB select tabRow.*;
/*but i want to update table TAB using variable rowTab*/
/* i know the list of colums that i want to update */
/*I've tr
On Thu, 19 Mar 2009, esemba wrote:
Hi,
I have table with several columns and need to perform fulltext search over
volatile number of columns.
I can't use multicolumn gist index or gin index over concatenated columns,
so I've created several single column indexes (one for each column I want to
s
Sam Mason wrote:
On Thu, Mar 19, 2009 at 04:22:56PM +0200, Peter Eisentraut wrote:
Joins nest from left to write, so
tbl_c NATURAL JOIN tbl_a NATURAL JOIN tbl_b
means
(tbl_c NATURAL JOIN tbl_a) NATURAL JOIN tbl_b
If you want a different order, you can set the parentheses differently,
with p
esemba wrote:
> Hi,
> I have table with several columns and need to perform fulltext search over
> volatile number of columns.
> I can't use multicolumn gist index or gin index over concatenated columns,
> so I've created several single column indexes (one for each column I want to
> search) and n
Martijn van Oosterhout wrote:
> True, but the relative wakeup order of two different processes is not
> important since by definition they are working on different
> transactions. As long as the WAL writes for a single transaction (in a
> single process) are not reordered you're fine.
I'm not tota
John Cheng wrote:
>> This is question for Juan, have you asked the MySQL mailing list?
I'm afraid MySQL general list isn't as dynamic as PostgreSQL general list.
http://lists.mysql.com/mysql/216795
MySQL general list: 4 answers in about 48 hours
PostgreSQL general list: 27 answers in about 72 h
Well, thank you both for response, but I'm not sure, I understand Oleg's
solution. This would work, but where is the variability of searched columns?
In your example, I create new indexed column with concatenated vectors of 2
columns. But I sometimes new to search only annotation, sometimes resume
There is a proposal being discussed on the hackers list about adding
gettext plural support to the national language support (NLS) feature
(--enable-nls) in the upcoming PostgreSQL 8.4. This would mean that
plurals of translated messages (e.g., in psql: 1 row/n rows) will work
properly in lang
Hello
it isn't correct comparation.
MySQL people use mainly web forum
regards
Pavel Stehule
2009/3/20 Juan Pereira :
> John Cheng wrote:
>
>>> This is question for Juan, have you asked the MySQL mailing list?
>
> I'm afraid MySQL general list isn't as dynamic as PostgreSQL general list.
>
> htt
Hello,
I try to use the srf API and I have a link error. When I did :
FuncCallContext *funcctx;
...
if (SRF_IS_FIRSTCALL()){
funcctx = SRF_FIRSTCALL_INIT(); // If I remove this line, no link
error
...
}
I have this link error : "undefined reference to
'init_MultiFuncCal
Hi,
I'm getting a new notebook and want to confirm that my idea on how to move my
Postgres installation will work This is a development/test installation and not
a production system, so it doesn't need to be 100% fail safe.
Both systems are Windows XP 32bit.
My plan was to install the same PG
> That's why I was looking for a more balanced benchmark that exercises
> said capabilities.
OK, here's the thing, I will give you *one* sample issue to think about, as
an illustration of the kinds of differences there are.
- PostgresQL uses MVCC instead of row or page locking, which means only
w
Ben Ali Rachid writes:
> I have this link error : "undefined reference to
> 'init_MultiFuncCall(FunctionCallInfoData*)'".
The fact that the linker knows the argument data type indicates that
you're trying to compile your code as C++. Postgres is written in C,
not C++.
You can try putting exter
On Fri, 2009-03-20 at 09:33 -0600, Scott Ribe wrote:
> > Hopefully we regard it as a missing feature rather than as a separate
> > definition. We could cluster the index, we just don't, yet.
>
> Wouldn't this require keeping around multiple versions of index pages for
> MVCC?
No, it wouldn't re
> Just think one index tuple points to more than one heap row. We would
> still need to check visibility on the rows returned to ensure MVCC.
So you wind up with the heap rows stored in their own tree-like structure
outside the index? OK.
--
Scott Ribe
scott_r...@killerbytes.com
http://www.kille
You have a point, as do a lot of the other folks.
However, keeping the KISS principle in mind, you can create a benchmark
that simply sets up a sample database and forks off a bunch of processes
to do random updates for an hour, say. Dead simple.
In fact, it's so simple that I've already written
On Fri, Mar 20, 2009 at 9:55 AM, Will Rutherdale (rutherw)
wrote:
> You have a point, as do a lot of the other folks.
>
> However, keeping the KISS principle in mind, you can create a benchmark
> that simply sets up a sample database and forks off a bunch of processes
> to do random updates for an
"Will Rutherdale (rutherw)" writes:
> However, keeping the KISS principle in mind, you can create a benchmark
> that simply sets up a sample database and forks off a bunch of processes
> to do random updates for an hour, say. Dead simple.
Indeed, and more than likely dead useless. The only benc
On Thu, 19 Mar 2009, Dann Corbit wrote:
Oracle won't let you publish any benchmark numbers.
So if you find an Oracle comparison, it's "unauthorized"
You can find some useful comparisons that include Oracle if you look at
the audited benchmarks from the TPC. I've collected links to a bunch at
Hello,
I serve a Geospatial IS project that for some years has used PostgreSQL
and PostGIS. A strategy/scheme that has worked for all previous
versions has failed with a recent upgrade to 8.3 (e.g. 8.3.6-1).
Relation "catalog" is a large geospatially-enabled aggregation of data
with a varie
On Fri, 20 Mar 2009, Will Rutherdale (rutherw) wrote:
However, keeping the KISS principle in mind, you can create a benchmark
that simply sets up a sample database and forks off a bunch of processes
to do random updates for an hour, say. Dead simple.
There's a benchmark tool that does somethi
http://blog.redfin.com/devblog/2007/11/elephant_versus_dolphin_which_is_faster_which_is_smarter.html
Here's another PgSQL/MySQL testimonial, with a spatial twist :)
P
On Fri, Mar 20, 2009 at 10:15 AM, Greg Smith wrote:
> On Fri, 20 Mar 2009, Will Rutherdale (rutherw) wrote:
>
>> However, keepin
On Fri, 20 Mar 2009, esemba wrote:
Well, thank you both for response, but I'm not sure, I understand Oleg's
solution. This would work, but where is the variability of searched columns?
In your example, I create new indexed column with concatenated vectors of 2
columns. But I sometimes new to se
Thanks for your help. I try "extern C" for the inclusions and everything is OK.
But now I have execution error (server crash), but it's another problem that I
will try to solve.
--- En date de : Ven 20.3.09, Tom Lane a écrit :
De: Tom Lane
Objet: Re: [GENERAL] Srf function : missing library
Point taken.
Thank you for the help.
-Will
-Original Message-
From: Tom Lane [mailto:t...@sss.pgh.pa.us]
Sent: 20 March 2009 12:06
To: Will Rutherdale (rutherw)
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] Is there a meaningful benchmark?
"Will Rutherdale (rutherw)" write
Thanks for the references.
-Will
-Original Message-
From: pgsql-general-ow...@postgresql.org
[mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Paul Ramsey
Sent: 20 March 2009 13:29
To: pgsql-general@postgresql.org
Subject: Re: [GENERAL] Is there a meaningful benchmark?
http://bl
Ron Mayer wrote:
> Marco Colombo wrote:
>> Yes, but we knew it already, didn't we? It's always been like
>> that, with IDE disks and write-back cache enabled, fsync just
>> waits for the disk reporting completion and disks lie about
>
> I've looked hard, and I have yet to see a disk that lies.
No
> Hopefully we regard it as a missing feature rather than as a separate
> definition. We could cluster the index, we just don't, yet.
Wouldn't this require keeping around multiple versions of index pages for
MVCC? Which would create performance degradations elsewhere?
--
Scott Ribe
scott_r...@ki
Sanjay Arora wrote:
>
> Hello all
>
> Is it possible to host postgreSQL on Amazon's cloud? What are the issues
> involved?
>
> With best regards.
> Sanjay.
>
>
You create postgres on EC2 in the same way you would on any Linux server. I
created one on the Amazon-Fedora AMI about a year and h
Thanks, this works quite fine, but I've ran into some problems so far:
- It's not possible to specify more than 4 labels (just ABCD)
- In query I have to specify searched vectors for each lexem. I think It
would be better to specify searched vectors per-query.
Oleg Bartunov wrote:
>
> On Fri, 2
This should be addressed to the Postgis list.
However, you are spatially joining two geometries, and they need be in the same
coordinate system.
The column "the_geom" has a defined SRID (spatial reference id) when created in
it's original table. Your hard coded POLYGON in the SQL below has a SR
csmith writes:
> ... It's as if the
> query is considering tuples in "catalog" outside of the view's domain.
This isn't particularly surprising: the planner will feel free to push
that WHERE condition down as far as it can. Probably there is some
aspect of the view definition that prevented suc
Hi folks,
I am holding hierarchical data in a table and often need to calculate the
"root" of a hierarchy. Initially, a recursive plpgsql function worked just
fine. But performance started to lag when I got to scale.
So, I added a functional index.
create table example (id serial primary key
You would get better results if you posted in mysql forums.
http://forums.mysql.com/
Amitabh
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
when importing from oracle 10g, i get "multiple step ole db generated
error". i narrowed this down to a date/timestamp column - actually to
about 100 rows within that column, all = '01-JAN-01' (never null).
there is another date/timestamp column that gets imported error-free,
and other tables also
37 matches
Mail list logo
