After dropping an index to do some full-table updating, I'm running
into an out of memory issue recreating one of my indices. This is on
8.3 running on linux.
The table in question has about 300m rows. The index is on a single
integer column. There are approximately 4000 unique values among the
ro
Alright, my benchmarks might have been a bit naïve.
When it comes to hardware, my webserver is a SunFire X2100 with an
Opteron 1210 Dual Core and 4 GB DDR2 RAM, running 64-bit Ubuntu Linux
Server 8.04 LTS.
When it comes to the resource usage section of my postgresql.conf, the
only thing th
> I have been testing it a bit performance-wise, and the numbers are
> worrying. In my test, MySQL (using InnoDB) had a 40% lead in
> performance, but I'm unsure whether this is indicative for PostgreSQL
> performance in general or perhaps a misconfiguration on my part.
In my experience the "numbe
* Mikkel Høgh ([EMAIL PROTECTED]) wrote:
> I have been testing it a bit performance-wise, and the numbers are
> worrying. In my test, MySQL (using InnoDB) had a 40% lead in
> performance, but I'm unsure whether this is indicative for PostgreSQL
> performance in general or perhaps a misconfigu
On Sun, Oct 12, 2008 at 9:57 PM, Mikkel Høgh <[EMAIL PROTECTED]> wrote:
> Hi there,
>
> I've been toying with using PostgreSQL for some of my Drupal sites for some
> time, and after his session at OpenSourceDays in Copenhagen last weekend,
> Magnus Hagander told me that there a quite a few in the P
On Oct 12, 2008, at 11:57 PM, Mikkel Høgh wrote:
In any case, if anyone has any tips, input, etc. on how best to
configure PostgreSQL for Drupal, or can find a way to poke holes in
my analysis, I would love to hear your insights :)
I just came across this article about moving Drupal from
Hi there,
I've been toying with using PostgreSQL for some of my Drupal sites for
some time, and after his session at OpenSourceDays in Copenhagen last
weekend, Magnus Hagander told me that there a quite a few in the
PostgreSQL community using Drupal.
I have been testing it a bit performan
On Sun, Oct 12, 2008 at 8:10 PM, Ben Chobot <[EMAIL PROTECTED]> wrote:
> On Oct 12, 2008, at 5:51 PM, Martin Gainty wrote:
> > could you provide a brief explanation of EAV ?
>
> (...) in an EAV model you would do something like:
> create table eav
> (
> kind text primary key,
> attr text,
> value t
On Oct 12, 2008, at 5:51 PM, Martin Gainty wrote:
could you provide a brief explanation of EAV ?
Instead of:
create table vehicles
(
kind text primary key,
wheels int
);
insert into vehicles (kind, wheels) values ('car',4);
insert into vehicles (kind, wheels) values ('bike',2
You are making this far to complicated.
I just redid the accounting side of an application we have access to
source code, so been here and done this.
If i was not for the rest of the application i would have completely
redone the accounting table layout something like this
3 Accounting Tabl
could you provide a brief explanation of EAV ?
thx
Martin
__
Disclaimer and confidentiality note
Everything in this e-mail and any attachments relates to the official business
of Sender. This transmission is of a confidential nature and Sender does
admin wrote:
> Sorry folks, a perennial one I'm sure ...
>
> I have read the manual and Googled for a couple of hours but still can't
> connect to PostgreSQL 8.3.4 (the PGDG RPMs running on an up to date
> CentOS 5.2).
>
> I continually get this message:
>
> psql: could not connect to server: No
that would be a type mismatch, heh.
Hi,
Released new sets:
http://people.planetpostgresql.org/devrim/index.php?/archives/124-New-shapshot-RPMs-Oct-11-2008-are-ready-for-testing.html
Regards,
--
Devrim GÜNDÜZ, RHCE
devrim~gunduz.org, devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr
http://www.gunduz.org
signa
On 12/10/2008 04:55, Raj K wrote:
> Since it is in windows - I could not find any specific file
> permission mechanisms similar to linux.
To see the file permissions, right-click on the file and look at the
"Security" tab - it lists users and their permissions on the file.
Ray.
-
On Sun, Oct 12, 2008 at 08:12:40PM +0100, I wrote:
> As always, it's a trade off between what you're optimizing for. If
> you're adding more preference types then go for a EAV style design, if
> you're going to want to add more details about the preferences (this
> does seem to be the common case,
On Sat, Oct 11, 2008 at 05:10:26PM +, Matthew Wilson wrote:
> I need to track employees and their preferred locations, shifts, and
> stations.
As always there's a trade off between "general" EAV style designs and
more specific ones (as noted by Jeff). One, more EAV style, design that
sprung t
On Sun, 2008-10-12 at 09:25 +0530, Raj K wrote:
> Since it is in windows - I could not find any specific file permission
> mechanisms similar to linux. (This is my first foray in windows - so I
> am a newbie there too )
> The computer is not in a network. So, through googling, I found that
> to sha
On Oct 11, 2008, at 6:41 PM, Joshua Tolley wrote:
On Thu, Oct 9, 2008 at 2:37 AM, Galland Gregoire
<[EMAIL PROTECTED]> wrote:
Hi all!
I would like to run all my databases in a readonly mode just for a
few
hours (migration plan).
Is it a way to tell the postgresql engine to run in readonl
Dear All,
I have just started experimenting with PGSQL, with a view to migrate from the
SQL server I use currently. I am trying to implement an "intelligent" Chart of
Accounts for an accounting program. The following is long-winded but please
bear with me:
I have a table coa (chart of accoun
Hello
2008/10/12 Grzegorz Jaśkiewicz <[EMAIL PROTECTED]>:
> I don't see that working using arrays here. Can you elaborate please ?
>
select * from foo where a = any ($1)
postgres=# select 1 = any(array[1,2,3]);
?column?
--
t
(1 row)
regards
Pavel Stehule
--
Sent via pgsql-general ma
knee deep in a schema design myself ..curious as to which advice did jeff offer
for schema design?
thanks
Martin
__
Disclaimer and confidentiality note
Everything in this e-mail and any attachments relates to the official business
of Sender. This t
I don't see that working using arrays here. Can you elaborate please ?
Jeff, this is *exactly* the kind of feedback I was hoping to get.
Thanks so much for the link and the explanation.
Matt
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
24 matches
Mail list logo
