you could try SQLWorkbench (http://www.sql-workbench.net/)
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
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
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
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
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
@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.
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
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.
>
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
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
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
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
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
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
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
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
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
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
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,
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).
>
> >
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
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?
>
> >
> >
> >
> &
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
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
25 matches
Mail list logo
