Re: [GENERAL] Which CMS/Ecommerce/Shopping cart ?

hi , Thanks for several of the links that you guys posted. The issue is not that I am looking for consulting companies who will set up and optimize postgres+software. There are a million small firms that do M*SQL+ work. And I am looking to do that kind of work with clients - but I want

Re: [GENERAL] Which CMS/Ecommerce/Shopping cart ?

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.or

Re: [GENERAL] Which CMS/Ecommerce/Shopping cart ?

On Wed, 28 Jul 2010 18:56:56 -0400 Greg Smith 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 some projects

Re: [GENERAL] Dynamic data model, locks and performance

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 tab

Re: [GENERAL] postgres-8.4SS, pg_dump from macosx-10.6 has "ssl handshake error" 26% in

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

Re: [GENERAL] Dynamic data model, locks and performance

On Wed, Jul 28, 2010 at 10:15 PM, Pierre Thibault 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 buyers can search > adds

Re: [GENERAL] postgres-8.4SS, pg_dump from macosx-10.6 has "ssl handshake error" 26% in

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 , the Enterprise Postgres

Re: [GENERAL] Dynamic data model, locks and performance

2010/7/28 Craig Ringer > 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 not very specific. I hav

Re: [GENERAL] Dynamic data model, locks and performance

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 othe

Re: [GENERAL] Which CMS/Ecommerce/Shopping cart ?

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 onl

[GENERAL] Dynamic data model, locks and performance

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 mana

Re: [GENERAL] Comparison of Oracle and PostgreSQL full text search

On Wed, Jul 28, 2010 at 8:38 PM, Daniel Verite 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 current Oracle 11.

Re: [GENERAL] Which CMS/Ecommerce/Shopping cart ?

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 indi

Re: [GENERAL] Which CMS/Ecommerce/Shopping cart ?

On Wed, 28 Jul 2010 12:45:47 -0700 "Joshua D. Drake" 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 have are rest

[GENERAL] Danger of idiomatic plpgsql loop for merging data

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 i

Re: [GENERAL] Need help with full text index configuration

Brian Hirt 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 at all. So fo

Re: [GENERAL] Need help with full text index configuration

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 hit

[GENERAL] Pglesslog issue

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 is

Re: [GENERAL] Need help with full text index configuration

Brian Hirt 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 isn't really configur

Re: [GENERAL] How Big is Too Big for Tables?

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 t

[GENERAL] Need help with full text index configuration

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. The

Re: [GENERAL] Which CMS/Ecommerce/Shopping cart ?

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 yo

Re: [GENERAL] Which CMS/Ecommerce/Shopping cart ?

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 hav

Re: [GENERAL] How Big is Too Big for Tables?

On Wed, Jul 28, 2010 at 3:05 PM, P Kishor 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 in too many tabl

Re: [GENERAL] How Big is Too Big for Tables?

On Wed, Jul 28, 2010 at 1:38 PM, Stephen Frost 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 fair amount of

Re: [GENERAL] How Big is Too Big for Tables?

* 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 con

Re: [GENERAL] How Big is Too Big for Tables?

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 : > ... > > Two. Partitioning is n

Re: [GENERAL] order in which rules are executed

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 ran

Re: [GENERAL] Inheritance and trigger/FK propagation

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 t

Re: [GENERAL] How Big is Too Big for Tables?

2010/7/28 P Kishor : ... > 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 yearly tables wit

Re: [GENERAL] Inheritance and trigger/FK propagation

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

Re: [GENERAL] Incorrect FTS result with GIN index

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 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 windows versus

Re: [GENERAL] Want FUNCTION to return argv[0] thru argv[6]

On Wed, Jul 28, 2010 at 12:06 PM, Jerry Richards 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 PresRoute(int, int) RET

Re: [GENERAL] Comparison of Oracle and PostgreSQL full text search

Thomas Kellerer 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 > you used

Re: [GENERAL] How Big is Too Big for Tables?

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,

Re: [GENERAL] How Big is Too Big for Tables?

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 har

Re: [GENERAL] Which CMS/Ecommerce/Shopping cart ?

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 wrote: > > > Except for Drupal's partial

Re: [GENERAL] How Big is Too Big for Tables?

On Wed, Jul 28, 2010 at 12:03 PM, Joshua D. Drake 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 state, with a mult po

Re: [GENERAL] How Big is Too Big for Tables?

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. http://www.postgresql.org/docs/current/static/ddl-partiti

Re: [GENERAL] Which CMS/Ecommerce/Shopping cart ?

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:

Re: [GENERAL] How Big is Too Big for Tables?

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

Re: [GENERAL] How Big is Too Big for Tables?

2010/7/28 Bill Thoen : > 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

[GENERAL] How Big is Too Big for Tables?

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 I'm

[GENERAL] order in which rules are executed

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 (pgsql-general

[GENERAL] Want FUNCTION to return argv[0] thru argv[6]

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,

Re: [GENERAL] Comparison of Oracle and PostgreSQL full text search

On Tue, 27 Jul 2010 23:24:12 -0600, Scott Marlowe 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 licensing, (user/processor/s

Re: [GENERAL] Which CMS/Ecommerce/Shopping cart ?

> 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 i

Re: [GENERAL] Histogram generator

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; > > Tha

Re: [GENERAL] psql problem

On 07/27/2010 10:20 PM, Tom Lane wrote: Gary Fu 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 connection is 'idle'. By the

[GENERAL] First inserts are faster than second ones

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 CREA

Re: [GENERAL] Comparison of Oracle and PostgreSQL full text search

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: http://www.oracle.com/technetwork/licen

Re: [GENERAL] psql problem

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

Re: [GENERAL] Comparison of Oracle and PostgreSQL full text search

zhong ming wu wrote: > > On Tue, Jul 27, 2010 at 9:58 PM, Howard Rogers 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 publishi

Re: [GENERAL] Comparison of Oracle and PostgreSQL full text search

On Tue, Jul 27, 2010 at 9:58 PM, Howard Rogers 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. The good new

Re: [GENERAL] postgres-8.4SS, pg_dump from macosx-10.6 has "ssl handshake error" 26% in

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 , the Enterprise Postgres

Re: [GENERAL] Comparison of Oracle and PostgreSQL full text search

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,"

Re: [GENERAL] Comparison of Oracle and PostgreSQL full text search

2010/7/28 Thomas Kellerer : > 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 training (and costs), as