On 2013-03-13, Joe Van Dyk j...@tanga.com wrote:
--047d7b6226a405604904d7d09001
Content-Type: text/plain; charset=UTF-8
On Wed, Mar 13, 2013 at 8:47 AM, Steve Crawford
scrawf...@pinpointresearch.com wrote:
On 03/12/2013 09:05 PM, Perry Smith wrote:
To all who replied:
Thank you. ...
On Mar 12, 2013, at 8:09 PM, Joe Van Dyk j...@tanga.com wrote:
On Mar 12, 2013, at 8:42 AM, Perry Smith pedz...@gmail.com wrote:
The other thought is perhaps there is a snap shot type concept. I don't
see it in the list of SQL commands. A snap shot would do exactly what it
sounds
On 03/12/2013 09:05 PM, Perry Smith wrote:
To all who replied:
Thank you. ...
I had not seriously considered pg_dump / pg_restore because I assumed
it would be fairly slow but I will experiment with pg_restore and
template techniques this weekend and see which ones prove viable.
Another
On Wed, Mar 13, 2013 at 8:47 AM, Steve Crawford
scrawf...@pinpointresearch.com wrote:
On 03/12/2013 09:05 PM, Perry Smith wrote:
To all who replied:
Thank you. ...
I had not seriously considered pg_dump / pg_restore because I assumed it
would be fairly slow but I will experiment with
I tried posting this from Google Groups but I did not see it come through after
an hour so this may be a duplicate message for some.
The current testing technique for things like Ruby On Rails has three choices
but all of the choices will not work in my case.
The first choice is truncate
On 03/12/2013 08:41 AM, Perry Smith wrote:
One choice would be to create the database, use it, and then drop it for each
test. I would create the database from a template that already has data taken
from the production database (and probably trimmed down to a small subset of
it). This
On Mar 12, 2013, at 8:41 AM, Perry Smith pedz...@gmail.com wrote:
One choice would be to create the database, use it, and then drop it for each
test. I would create the database from a template that already has data
taken from the production database (and probably trimmed down to a
On Mar 12, 2013, at 8:42 AM, Perry Smith pedz...@gmail.com wrote:
I tried posting this from Google Groups but I did not see it come through
after an hour so this may be a duplicate message for some.
The current testing technique for things like Ruby On Rails has three
choices but all of the
To all who replied:
Thank you. I did typo. I meant transaction instead of truncate.
I had not seriously considered pg_dump / pg_restore because I assumed it would
be fairly slow but I will experiment with pg_restore and template techniques
this weekend and see which ones prove viable.
I