[PERFORM] Dynamic queries in stored procedure

2013-07-05 Thread Greg Jaskiewicz
Hey, We have a search method that depending on search params will join 3-5 tables, craft the joins and where section. Only problem is, this is done in rather horrible java code. So using pgtap for tests is not feasible. I want to move the database complexity back to database, almost writing the

[PERFORM] Proof of concept: Evolving postgresql.conf using genetic algorithm

2013-03-25 Thread Greg Jaskiewicz
(following the interest from -hackers, I'm posting this here). Hi folks, I've always been fascinated with genetic algorithms. Having had a chance to implement it once before, to solve real life issue - I knew they can be brilliant at searching for right solutions in multi dimensional space.

Re: [PERFORM] New server setup

2013-03-13 Thread Greg Jaskiewicz
On 13 Mar 2013, at 15:33, John Lister wrote: > On 12/03/2013 21:41, Gregg Jaskiewicz wrote: >> >> Whilst on the hardware subject, someone mentioned throwing ssd into the mix. >> I.e. combining spinning HDs with SSD, apparently some raid cards can use >> small-ish (80GB+) SSDs as external cach

Re: [PERFORM] does update of column with no relation imply a relation check of other column?

2011-10-19 Thread Greg Jaskiewicz
On 19 Oct 2011, at 17:51, Anibal David Acosta wrote: > For example: > Table A > -id (PK) > -name > > Table B > -table_a_id (PK, FK) > -address > > When I do an insert on table B, the database check if value for column > “table_a_id” exists in table A > But, if I do an update of column “addre