Hi,
Disclaimer: Not a DBA, nor I am not a DB guy, so please excuse any ignorance
in the below.
*1. Background*
We have a MS Access 2003 database that we are using to manage registration
and workshop/accommodation allocation for a conference. The database isn't
particularly complicated (around 20
Hi,
I have a Django application where we need to pull random rows out of a
table.
According to the Django documentation:
https://docs.djangoproject.com/en/dev/ref/models/querysets/#order-by
Note: order_by('?') queries may be expensive and slow, depending on the
> database backend you’re using.
ct things.
Are there any other database backends that do things differently?
(I know that SQL Server suggests using NEWID to do things -
http://msdn.microsoft.com/en-us/library/cc441928.aspx).
Cheers,
Victor
On Fri, Aug 9, 2013 at 10:43 AM, Sergey Konoplev wrote:
> On Wed, Aug 7, 2013 at
Hi,
We're using psycopg2 with COPY to dump CSV output from a large query.
The actual SELECT query itself is large (both in number of records/columns,
and also in width of values in columns), but still completes in around
under a minute on the server.
However, if you then use a COPY with it, it w
log_replay_resume()
>
>
>
>
> On Fri, Nov 8, 2013 at 10:06 AM, Victor Hooi wrote:
>
>> Hi,
>>
>> We're using psycopg2 with COPY to dump CSV output from a large query.
>>
>> The actual SELECT query itself is large (both in number of
>>
y are connected over the internet).
Cheers,
Victor
On Fri, Nov 8, 2013 at 1:44 PM, Victor Hooi wrote:
> Hi,
>
> Hmm, ok, I'll pass that onto our DBA/operations guys, and see if that
> helps.
>
> Do these settings still work if you only have a single Postgres instance?
>
er approach? Reasons?
(Not challenging it, I just want to understand everything).
Cheers,
Victor
On Fri, Nov 8, 2013 at 6:36 PM, Francisco Olarte wrote:
> On Fri, Nov 8, 2013 at 5:09 AM, Victor Hooi wrote:
> > They think that it might be limited by the network, and how fast the
>
