Tom Lane wrote:
raf r...@raf.org writes:
i'm having a little openssl problem with pg_dump over a wireless
lan with postgres-8.4SS (on linux) from enterprisedb and
a macosx-10.6 client.
when i run pg_dump from a wired linux client it's always fine
but since i switched from a
Howard Rogers, 28.07.2010 03:58:
Thanks to some very helpful input here in earlier threads, I was
finally able to pull together a working prototype Full Text Search
'engine' on PostgreSQL and compare it directly to the way the
production Oracle Text works. The good news is that PostgreSQL is
2010/7/28 Thomas Kellerer spam_ea...@gmx.net:
Why is it that managers always see short term savings but fail to see
longterm expenses?
It's all about CAPEX vs OPEX, baby!
Besides jokes, it's actually myopia.
Because they ALREADY spent money for training they don't see the need
for extra
Howard,
that was a great read!
I especially like your sentence
Considering that any search containing more than a half-dozen
search terms is more like an essay than a realistic search; and
considering that returning half a million matches is more a data dump
than a sensible search facility,
the latest enterprisedb standard server is only 8.4.1 (New! 13-Oct-09) :-)
By using the StackBuilder Plus application, you can upgrade your server
to 8.4.4.
--
Regards,
Sachin Srivastava
EnterpriseDB http://www.enterprisedb.com, the Enterprise Postgres
http://www.enterprisedb.com
On Tue, Jul 27, 2010 at 9:58 PM, Howard Rogers h...@diznix.com wrote:
Thanks to some very helpful input here in earlier threads, I was
finally able to pull together a working prototype Full Text Search
'engine' on PostgreSQL and compare it directly to the way the
production Oracle Text works.
zhong ming wu wrote:
On Tue, Jul 27, 2010 at 9:58 PM, Howard Rogers h...@diznix.com wrote:
For what it's worth, I wrote up the performance comparison here:
http://diznix.com/dizwell/archives/153
I always thought there is a clause in their user agreement preventing
the users from
Tom Lane wrote:
The openssl installation I'm testing with is
openssl-1.0.0a-1.fc13.x86_64
I don't know offhand what RHEL/CentOS 5.x are using but it's probably
quite a lot older.
Here's a CentOS 5.5 install that's kept up to date:
$ rpm -qi openssl
Name: openssl
zhong ming wu wrote:
I always thought there is a clause in their user agreement preventing
the users from publishing benchmarks like that. I must be mistaken.
No you're correct. Currently, to download the current Oracle 11.2g, one must
agree to:
Hi there.
I have a strange behaviour about INSERT execution. I have very dummy
PL/pgSQL function, which SELECT data from table; if data exists - skip, if
not - add one. It's about 3'000'000 execution per program life.
Everything works. But there are one weird thing. After DROP TABLE and then
On 07/27/2010 10:20 PM, Tom Lane wrote:
Gary Fugary...@sigmaspace.com writes:
Below is an example that I created. It works okay, but when I add any
character in the comment or in the table definition, it fails (hangs).
I checked the server process (with ps command), and I can see that
On Tue, Jul 27, 2010 at 09:25:05PM -0400, Patrick May wrote:
On Jul 27, 2010, at 9:21 PM, Steve Atkins wrote:
select date_trunc('hour', foo) + interval '30 minutes' *
floor(extract(minute from foo) / 30) as start, event, count(*) from bar
group by 1, 2 order by 1 asc;
Thanks! It
Except for Drupal's partial support, I cant find any which has a
sizeable
deployment and community size behind it. Spree is a new RoR based
system,
that would obviously work with PG, but doesnt have a sizeable deployment
base.
Drupal + Ubercart + a ton of their modules work great. It is
On Tue, 27 Jul 2010 23:24:12 -0600, Scott Marlowe
scott.marl...@gmail.com
wrote:
Someone running Oracle is complaining about training costs? That
seems a bit like complaining about needing to give the bellboy a $1
tip at a $1k a night hotel.
Depending on how they are running their
Hello,
I am using postgres-odbc and I created the following function which is
called from a C-application. This function returns a single argv[0] of the
form (a,b,c,d,e,f,g).
CREATE OR REPLACE FUNCTION PresRoute(int, int) RETURNS
TABLE(d1 text, d2 text, d3 text, d4 text, r1 bigint, r2 bigint,
Hello All,
I have the below query regarding Rules in PostgreSQL:
If I have a table which has multiple rules defined, are the rules
executed in the order in which they are defined?
Or are they executed in some random order?
Thanks,
Ranjeeth
--
Sent via pgsql-general mailing list
I'm building a national database of agricultural information and one of
the layers is a bit more than a gigabyte per state. That's 1-2 million
records per state, with a mult polygon geometry, and i've got about 40
states worth of data. I trying to store everything in a single PG table.
What
2010/7/28 Bill Thoen bth...@gisnet.com:
I'm building a national database of agricultural information and one of the
layers is a bit more than a gigabyte per state. That's 1-2 million records
per state, with a mult polygon geometry, and i've got about 40 states worth
of data. I trying to store
On Wed, 2010-07-28 at 11:09 -0600, Bill Thoen wrote:
I'm building a national database of agricultural information and one
of the layers is a bit more than a gigabyte per state. That's 1-2
million records per state, with a mult polygon geometry, and i've got
about 40 states worth of data. I
On Wed, 2010-07-28 at 22:37 +0530, Sandeep Srinivasa wrote:
Could you point me to any deployments of Drupal + Ubercart +
Postgres ?
Did you not see the links below?
Drupal + Ubercart + a ton of their modules work great. It is
what drives:
You should look at table partitioning. That is, you make a master
table and then make a table for each state that would inherit the
master. That way you can query each state individually or you can query
the whole country if need be.
On Wed, Jul 28, 2010 at 12:03 PM, Joshua D. Drake j...@commandprompt.com
wrote:
On Wed, 2010-07-28 at 11:09 -0600, Bill Thoen wrote:
I'm building a national database of agricultural information and one
of the layers is a bit more than a gigabyte per state. That's 1-2
million records per
Could you point me to any deployments of Drupal + Ubercart + Postgres ?
It felt really strange that nobody on IRC or forums could answer that they
had been involved in a postgres based deployment.
thanks!
On Wed, Jul 28, 2010 at 8:23 PM, Joshua D. Drake j...@commandprompt.comwrote:
Except
If all the table files are the same structure, its really not hard, just
a UNION clause.
Indeed, one can even create a VIEW that leverages that union clause to
simplify the code that needs to grab from the multiple tables.
As far as indexes, single table COULD be OK if you throw enough
Under the assumption that you properly modeled the data - achieved a
nice balance of normalization and de-normalization, examined the size of
your relations in such a context, and accounted for
how the data will grow over time and if it will grow over time, then
partitioning, as Joshua mentioned,
Thomas Kellerer spam_ea...@gmx.net writes:
Howard Rogers, 28.07.2010 03:58:
For what it's worth, I wrote up the performance comparison here:
http://diznix.com/dizwell/archives/153
Very interesting reading.
Indeed.
Would you mind sharing the tables, index structures and search queries that
On Wed, Jul 28, 2010 at 12:06 PM, Jerry Richards
jerry.richa...@teotech.com wrote:
Hello,
I am using postgres-odbc and I created the following function which is
called from a C-application. This function returns a single argv[0] of the
form (a,b,c,d,e,f,g).
CREATE OR REPLACE FUNCTION
Tom,
you can download dump http://mira.sai.msu.su/~megera/tmp/search_tab.dump
Oleg
On Tue, 27 Jul 2010, Tom Lane wrote:
Oleg Bartunov o...@sai.msu.su writes:
I recommend post your problem to -hackers mailing list. I have no idea,
what could be a problem.
I wonder whether the problem is not
On Tue, Jul 27, 2010 at 10:36:16AM +0200, Davor J. wrote:
For me Vick's question just proves that inheritance in relational databases
is a complex issue. It shows that trigger propagation is not always desired,
Now that's for sure :-)
Karsten
--
GPG key ID E4071346 @ wwwkeys.pgp.net
E167
2010/7/28 P Kishor punk.k...@gmail.com:
...
Two. Partitioning is not the perfect solution. My database will
ultimately have about 13 million rows per day (it is daily data) for
about 25 years. So, I need either --
- One big table with 25 * 365 * 13 million rows. Completely undoable.
- 25
On Tue, Jul 27, 2010 at 10:33:19AM +0200, Davor J. wrote:
Well... I found it out the hard way :). There are some extra caveats I have
come along. There is the very clumsy ALTER TABLE table_name
INHERIT(parent_table) which simply presupposes the parent's columns, but
doesn't enforce it
On Wed, Jul 28, 2010 at 10:16:45PM +0530, Ranjeeth Nagarajan wrote:
Hello All,
I have the below query regarding Rules in PostgreSQL:
If I have a table which has multiple rules defined, are the rules
executed in the order in which they are defined?
Or are they executed in some random
There are Postgres Enterprise solutions available although I think they are
commercial. You may want to take a look and see if they can be helpful to
you.
On Wed, Jul 28, 2010 at 8:44 PM, Vincenzo Romano
vincenzo.rom...@notorand.it wrote:
2010/7/28 P Kishor punk.k...@gmail.com:
...
Two.
* P Kishor (punk.k...@gmail.com) wrote:
Three. At least, in my case, the overhead is too much. My data are
single bytes, but the smallest data type in Pg is smallint (2 bytes).
That, plus the per row overhead adds to a fair amount of overhead.
My first reaction to this would be- have you
On Wed, Jul 28, 2010 at 1:38 PM, Stephen Frost sfr...@snowman.net wrote:
* P Kishor (punk.k...@gmail.com) wrote:
Three. At least, in my case, the overhead is too much. My data are
single bytes, but the smallest data type in Pg is smallint (2 bytes).
That, plus the per row overhead adds to a
On Wed, Jul 28, 2010 at 3:05 PM, P Kishor punk.k...@gmail.com wrote:
Keep in mind, the circa 100 million rows was for only part of the db.
If I were to build the entire db, I would have about 4 billion rows
for a year, if I were to partition the db by years. And, partitioning
by days resulted
yup I did. The reason why I wanted examples was to amply demonstrate,to
clients, that postgresql is viable.
It is kinda weird if the only examples I have are restricted to the
postgresql _community_ websites themselves.
This may sound irrelevant, but please do understand the huge opposition to
On Thu, 2010-07-29 at 00:36 +0530, Sandeep Srinivasa wrote:
yup I did. The reason why I wanted examples was to amply
demonstrate,to clients, that postgresql is viable.
It is kinda weird if the only examples I have are restricted to the
postgresql _community_ websites themselves.
Well you
I have some data that can be searched, and it looks like the parser is making
some assumptions about the data that aren't true in our case and I'm trying to
figure out how to exclude a token type. I haven't been able to find the
answer to my question so far, so I thought I would ask here.
On Wed, Jul 28, 2010 at 02:05:47PM -0500, P Kishor wrote:
each row is half a dozen single byte values, so, it is actually 6
bytes per row (six columns). Even if I combine them somehow, still the
per row overhead (which, I believe, is about 23 bytes) is more than
the data. But, that is not the
Brian Hirt bh...@mobygames.com writes:
For example instead of the parser recognizing three asciiword it recognizes
one asciiword and one file. I'd like a way to have the / just get parsed as
blank.
AFAIK the only good way to do that is to write your own parser :-(.
The builtin parser
Hi,
I was installed the Postgresql 8.3 and trying the use the
pg_lesslog_1.4.1_pg83 to reduce the size of WAL file when the WAL file is
archived.
1. Download the pg_lesslog_1.4.1_pg83.tar.gz file from pgfoundry.
2. unpacked the pglesslog source.
3. trying to run the make...facing below issue::
Tom,
Thanks for the quick reply. Doing a frontend mapping was my next option since
I really don't care about / and the ability to search on it. Preventing the
parser from using the file tokenizer seemed like a better solution so I wanted
to go down that path first (there are other false
Brian Hirt bh...@mobygames.com writes:
I'm really confused about what ALTER TEXT SEARCH CONFIGURATION dict DROP
MAPPING FOR file actually does. The documentation seems to make it sound
like it does what I want, but I guess it does something else.
No, it doesn't affect the parser's behavior
Hi fellow PostgreSQL hackers,
I just got burned by the idiomatic loop
documented in the PostgreSQL manual as
Example 39-2. Exceptions with UPDATE/INSERT
I have now replaced this standard idiom
with a safer one described below.
What went wrong:
It seems that the table I was either
inserting
On Wed, 28 Jul 2010 12:45:47 -0700
Joshua D. Drake j...@commandprompt.com wrote:
On Thu, 2010-07-29 at 00:36 +0530, Sandeep Srinivasa wrote:
yup I did. The reason why I wanted examples was to amply
demonstrate,to clients, that postgresql is viable.
It is kinda weird if the only examples I
Ivan Sergio Borgonovo wrote:
Are there companies that offer drupal/postgres tuning?
I am quite sure that Command Prompt would be happy and fully prepared to
sell you Drupal + PostgreSQL tuning services. We also have some
projects around it, and I'm sure other consulting companies or
On Wed, Jul 28, 2010 at 8:38 PM, Daniel Verite dan...@manitou-mail.org wrote:
zhong ming wu wrote:
I always thought there is a clause in their user agreement preventing
the users from publishing benchmarks like that. I must be mistaken.
No you're correct. Currently, to download the
Hello people of the Postgresql world!
I am wondering if Postgresql would a great choice for my database needs.
I would like to create a db with dynamic data model. I would like to be able
to add tables and columns to existing tables while other queries are
running.
Will Postresql be able to
the one drupal programmer that programmed the system quit to do other things
multi-threaded issues..integration with external security..
and/or anything critical / mildly useful will send you into support h*ll
one stock form with no integration with clients database or j2ee server hosted
On 29/07/10 07:06, Pierre Thibault wrote:
Hello people of the Postgresql world!
I am wondering if Postgresql would a great choice for my database needs.
I would like to create a db with dynamic data model. I would like to be
able to add tables and columns to existing tables while other
2010/7/28 Craig Ringer cr...@postnewspapers.com.au
On 29/07/10 07:06, Pierre Thibault wrote:
I doubt anyone can make any useful recommendations without a more
complete explanation of what you're trying to achieve and why you want
to do what you have described.
Thank you Craig,
Yes, I was
Sachin Srivastava wrote:
the latest enterprisedb standard server is only 8.4.1 (New! 13-Oct-09) :-)
By using the StackBuilder Plus application, you can upgrade your server
to 8.4.4.
--
Regards,
Sachin Srivastava
EnterpriseDB http://www.enterprisedb.com, the Enterprise Postgres
On Wed, Jul 28, 2010 at 10:15 PM, Pierre Thibault
pierre.thibau...@gmail.com wrote:
What I would like to do is enable users to create their own data model.
Enable them to create a model and make it evolve. For example, it would be
cool to create a model to represent car adds. Then, the
raf wrote:
Sachin Srivastava wrote:
the latest enterprisedb standard server is only 8.4.1 (New! 13-Oct-09) :-)
By using the StackBuilder Plus application, you can upgrade your server
to 8.4.4.
--
Regards,
Sachin Srivastava
EnterpriseDB http://www.enterprisedb.com, the
On 29/07/10 11:15, Pierre Thibault wrote:
What I would like to do is enable users to create their own data model.
Then, really, SQL databases aren't wonderful for your needs. You can use
them for dynamic, user-defined schema, but you'll always be swimming up
hill.
I thought about using a
On Wed, 28 Jul 2010 18:56:56 -0400
Greg Smith g...@2ndquadrant.com wrote:
Ivan Sergio Borgonovo wrote:
Are there companies that offer drupal/postgres tuning?
I am quite sure that Command Prompt would be happy and fully
prepared to sell you Drupal + PostgreSQL tuning services. We also
have
On Thu, 2010-07-29 at 07:04 +0200, Ivan Sergio Borgonovo wrote:
BTW up to my memory Django suggest postgres. I haven't seen any
benchmark of Django with pg vs mysql.
Django was originally developed for Postgres but really, they are wholly
different beasts.
Joshua D. Drake
--
PostgreSQL.org
58 matches
Mail list logo