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
I don't see that working using arrays here. Can you elaborate please ?
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
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
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
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
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 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, 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 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.
-
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
that would be a type mismatch, heh.
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
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
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
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
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
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 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
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
* 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
> 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
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
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
24 matches
Mail list logo
