Tag Info

New answers tagged

0

This could be really useful : https://gist.github.com/ibussieres/11262268 It's for 12.04, but I'm guessing it's fairly transferable.


1

I would write the raw data to a very basic table without indexes or constraints, not even a primary key. If you can, insert many rows at once, that's faster than single-row inserts. If you can afford loosing some data in a catastrophic event, make that an unlogged table, that's faster. If you can afford loosing some data in a catastrophic event and all ...


1

You were close. Your last idea is actually the way to go: log_statement = none log_min_duration_statement = 10000 Then no statement will be logged, except those running longer than 10 seconds - including the query string itself. Logging may have seemed to stop because 10 seconds is a high threshold. I am using 2 seconds normally, but YMMV. This related ...


0

Your regexp_replace() statement is invalid. It would work like this: SELECT regexp_replace(tbl, '('''')$', '' , 'g') FROM ( VALUES ('6''''') ,('6''''') ,('6''''') ,('20''''') ,('12''''') ,('18''''') ,('20''''') ,('8''''') ,('10''''') ,('''''') ,('''''') ) tbl(tbl) Your SELECT INTO statement is invalid. It would look like this: SELECT ...



Top 50 recent answers are included