[GENERAL] Polymorphic queries

2015-07-06 Thread Patric Bechtel
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi, maybe someone has an idea upon this: I have a table which has quite a few inheriting tables which have inheriting tables etc (it's mirroring a OOP model). As expected, most queries are polymorphic, so they are going against the parent tables.

Re: [GENERAL] Postgresql 9.4 and ZFS?

2015-09-29 Thread Patric Bechtel
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi Benjamin, if you're using compression, forget about that. You need to synchronize the ashift value to the internal rowsize of you SSD, that's it. Make sure your SSD doesn't lie to you regarding writing blocks and their respective order. In that c

Re: [GENERAL] Postgresql 9.4 and ZFS?

2015-09-30 Thread Patric Bechtel
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi Tomas, Tomas Vondra schrieb am 30.09.2015 um 14:01: > Hi, > > On 09/30/2015 12:21 AM, Patric Bechtel wrote: >> -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 >> >> Hi Benjamin, >> >> if you're using

Re: [GENERAL] can postgres run well on NFS mounted partitions?

2015-11-09 Thread Patric Bechtel
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi Anj, anj patnaik schrieb am 06.11.2015 um 23:37: > Can anyone advise if there are problems running postgres over NFS mounted > partitions? > > I do need reliability and high speed. then don't do this. Period. Put postgres where your data is. /P

[GENERAL] Regression in 8.3?

2007-11-11 Thread Patric Bechtel
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi, just compiled a fresh 8.3 on my Ubuntu Gutsy, but there's one thing which seems to have changed though I cannot get any hint about that in the docs: Given a table bla(a bigint,b text) select * from bla where a like '8%' works in <=8.2, but not

Re: [GENERAL] Regression in 8.3?

2007-11-12 Thread Patric Bechtel
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Karsten Hilbert schrieb am 12.11.2007 13:07: > On Mon, Nov 12, 2007 at 12:46:58AM +0100, Patric Bechtel wrote: > >> select * from bla where a like '8%' > > Patrick, I'm not sure what you expect to come back: &

Re: [GENERAL] Regression in 8.3?

2007-11-12 Thread Patric Bechtel
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Thomas Pundt schrieb am 12.11.2007 13:18: > Hi, > > On Montag, 12. November 2007, Karsten Hilbert wrote: > | On Mon, Nov 12, 2007 at 12:46:58AM +0100, Patric Bechtel wrote: > | > select * from bla where a like '8%' > |