[GENERAL] Which CMS/Ecommerce/Shopping cart ?

2010-07-27 Thread Sandeep Srinivasa
hi, The question is very simple - which CMS/Shopping cart/Ecommerce solution are people using in conjunction with Postgresql ? 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

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

2010-07-28 Thread Sandeep Srinivasa
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] Which CMS/Ecommerce/Shopping cart ?

2010-07-28 Thread Sandeep Srinivasa
On Wed, Jul 28, 2010 at 10:40 PM, Joshua D. Drake wrote: > 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? > > > > > > > > &

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

2010-07-28 Thread Sandeep Srinivasa
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 ?

2010-07-29 Thread Sandeep Srinivasa
On Thu, Jul 29, 2010 at 10:46 PM, Ivan Sergio Borgonovo < m...@webthatworks.it> wrote: > On Thu, 29 Jul 2010 08:52:46 -0700 > "Joshua D. Drake" wrote: > > > The issue isn't Drupal. It is modules. There are a lot of popular > > modules that do not work with PostgreSQL (Lightbox for example). > > >

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

2010-07-29 Thread Sandeep Srinivasa
On Fri, Jul 30, 2010 at 3:05 AM, John Gage wrote: > Shopping carts, company blogs, etc. Popular pieces of software. > > As common denominators go, that's pretty low. > > Perhaps what is needed is a dumbed down version of Postgres. > I dont think that is what is required - as I mentioned above,

Re: [GENERAL] MySQL versus Postgres

2010-08-06 Thread Sandeep Srinivasa
On Sat, Aug 7, 2010 at 12:29 AM, Joshua J. Kugler wrote: > > So, a "getting started" guide and/or cookbook would be great. Another > cool idea: a MySQL -> PostgreSQL migration guide (I'm sure there's > already one out there) that would show "To do *this* MySQL function in > PostgreSQL, use this f

Re: [GENERAL] MySQL versus Postgres

2010-08-09 Thread Sandeep Srinivasa
On Mon, Aug 9, 2010 at 12:15 PM, Allan Kamau wrote: > > There may be worry of "copy and paste" without proper understanding of > the code and concepts but this may be mitigated IMHO by fact that it > seems unlikely that when presented with a case to solve, simple "copy > and paste" of several com

Re: [GENERAL] MySQL versus Postgres

2010-08-09 Thread Sandeep Srinivasa
On Mon, Aug 9, 2010 at 2:28 PM, Michael A. Peters wrote: > > > I have 4x6 cards that I write the postgresql way of doing what I use to do > with MySQL so that I can easily reference them when I need to. > > Should I sit down and read a book and go through the exercises? > Yes. But I need to get stu

Re: [GENERAL] MySQL versus Postgres

2010-08-11 Thread Sandeep Srinivasa
On Thu, Aug 12, 2010 at 10:53 AM, Greg Smith wrote: > > If only it were that easy. 25%, but only on a dedicated server, don't go > above 8GB, limit to much less than that on Windows, and be extremely careful > if you're writing heavily lest large checkpoints squash you. Giving simple > advice th

Re: [GENERAL] MySQL versus Postgres

2010-08-12 Thread Sandeep Srinivasa
On Thu, Aug 12, 2010 at 12:37 PM, Scott Marlowe wrote: > On Wed, Aug 11, 2010 at 11:41 PM, Greg Smith wrote: > > Sandeep Srinivasa wrote: > >> > >> Maybe a tabular form would be nice - "work_mem" under... > > > > The problem with work_mem in part

[GENERAL] .psqlrc and custom functions (mysql-like)

2010-08-14 Thread Sandeep Srinivasa
hi, As part of a product we are building, we are using postgres as our database. But most of our developers have a (loud) mysql background. I want to potentially provide "aliases" for a few commonly used mysql functions. I see that the .psqlrc could potentially be the place where you could defi

[GENERAL] Relationship between ulimit and effective_cache_size, work_mem, shared_buffers, maintenance_work_mem and vacuum

2010-08-15 Thread Sandeep Srinivasa
hi guys, we have a single Ubuntu 10.04 box on which we are going to be running a Postgres 8.4 server, ROR passenger and a solr search server. I was looking at ways to optimize the postgres database and yet limit the amount of memory that it can consume. I am gonna set my shared_buffer

Re: [GENERAL] Relationship between ulimit and effective_cache_size, work_mem, shared_buffers, maintenance_work_mem and vacuum

2010-08-16 Thread Sandeep Srinivasa
Thanks for the comprehensive reply. It definitely cleared a lot of things up for me. regards Sandeep On Mon, Aug 16, 2010 at 12:39 PM, Greg Smith wrote: > Sandeep Srinivasa wrote: > >> >> I was looking at ways to optimize the postgres database and yet limit the >> amou

Re: [GENERAL] searchable book database

2010-08-19 Thread Sandeep Srinivasa
If you dont ever need to return the complete book text to a user (which means, you only need the book text for your search indexes only), then keep the text on file and use Apache Solr to index it. regards Sandeep On Fri, Aug 20, 2010 at 1:05 AM, Miguel Vaz wrote: > > Hi, > > I need to make a d

Re: [GENERAL] postgres.conf settings

2010-08-29 Thread Sandeep Srinivasa
Do check a previous thread: http://www.mail-archive.com/pgsql-general@postgresql.org/msg149691.html On Sun, Aug 29, 2010 at 10:32 PM, Dario Beraldi wrote: > Hello, > > I'm trying to tune the parameters in postgres.conf to improve the > performance of my database (where performance = 'make queries

Re: [GENERAL] where does postgres keep the query result until it is returned?

2010-09-20 Thread Sandeep Srinivasa
On Mon, Sep 20, 2010 at 5:27 PM, Merlin Moncure wrote: > On Fri, Sep 17, 2010 at 3:59 PM, Sam Mason wrote: > > On Fri, Sep 17, 2010 at 04:51:46PM +0200, Willy-Bas Loos wrote: > >> i have a function that produces a result in xml. > >> that is one row, one value even, but it grows pretty large. >

Re: [GENERAL] Unable to upgrade old cluster from 8.4 to 9.0

2010-09-23 Thread Sandeep Srinivasa
There is already a bug filed for this: http://bugs.debian.org/597600 According to mpitt (the maintainer), the supported upgrade path is to use pg_upgradecluster On Thu, Sep 23, 2010 at 3:21 PM, Boris wrote: > Hello, > > I have Debian Linux (unstable) server, and I am trying to upgrade 8.4 > v

Re: [GENERAL] Trade Study on Oracle vs. PostgreSQL

2010-09-25 Thread Sandeep Srinivasa
@OP - One of the things you _might_ be interested in is the difference in tracing and performance framework between Oracle and Postgres. There was a recent thread about it - http://osdir.com/ml/pgsql-general/2010-09/msg00308.html You could get your company to sponsor some work on that front.

[GENERAL] Postgres, DB2 and Materialized Query Tables (MQTs - DB2s Materialized Views)

2010-10-05 Thread Sandeep Srinivasa
Below is an excerpt from a comment over at Reddit. It seemed quite interesting to read about the difference in PG and DB2's query optimizer. Can anybody shed any more light on this ? -Sandeep -- there are a couple really important things that DB2 does with Materialized

[GENERAL] Why facebook used mysql ?

2010-11-08 Thread Sandeep Srinivasa
There was an interesting post today on highscalability - http://highscalability.com/blog/2010/11/4/facebook-at-13-million-queries-per-second-recommends-minimiz.html The discussion/comments touched upon why mysql is a better idea for Facebook than Postgres. Here's an interesting one > One is that

Re: [GENERAL] Why facebook used mysql ?

2010-11-08 Thread Sandeep Srinivasa
On Tue, Nov 9, 2010 at 10:31 AM, Richard Broersma < richard.broer...@gmail.com> wrote: > The following link contains hundreds of comments that you may be > interested in, some that address issues that are much more interesting > and well established: > > > http://search.postgresql.org/search?q=mys

Re: [GENERAL] Why facebook used mysql ?

2010-11-09 Thread Sandeep Srinivasa
hi, I am the OP. With due respect to everyone (and sincere apologies to Richard Broersma), my intention was not to create a thread about MySQL/Oracle's business practices. It was about the technical discussion on Highscalability - I have been trying to wrap my head around the concept of multip

Re: [GENERAL] Why facebook used mysql ?

2010-11-09 Thread Sandeep Srinivasa
On Tue, Nov 9, 2010 at 11:46 PM, David Boreham wrote: > > > Hmm...typically multi-core scaling issues are in the area of memory > contention and cache coherence (and therefore are for the most part not > dependent on the OS and its scheduler). If it is independent of the OS, then how does one go

Re: [GENERAL] Simple, free PG GUI/query tool wanted

2010-12-16 Thread Sandeep Srinivasa
you could try SQLWorkbench (http://www.sql-workbench.net/)