On Mon, 2 Dec 2013 15:46:17 -0800, Nick wrote:
[...]
> This is what I have currently for the line that I am specifically talking
> about:
>
> INSERT INTO club_Games(memberID, gameID, hardwareID, count, status)
>VALUES ((SELECT memberID FROM members WHERE name = 'Fred Flinstone'),
> (SELEC
On Fri, 1 Feb 2013 10:38:26 +0100, Alexander Farber wrote:
> Hello,
>
> in a Facebook game running on
> PostgreSQL 8.4.13 and having so many players:
>
> # select count(*) from pref_users;
> count
>
> 223964
>
> I am trying to get rid of inactive users,
> who just visited the canvas
On Fri, 3 Jun 2011 09:53:59 -0400, Tom Lane wrote:
[...]
> You'd probably be better off asking these questions in pgsql-jdbc ...
> a lot of us here don't even speak Java.
Good point. Will try the other list. Thank you for your help.
--
Michał Politowski
Talking has been known to lead to communi
On Thu, 2 Jun 2011 08:50:30 +0800, Craig Ringer wrote:
> On 1/06/2011 9:06 PM, Michal Politowski wrote:
>
> >What may be the cause of this weird problem? Is it some known or unknown bug
> >in
> >8.3.4 or is the application/Java side more suspected?
>
> It&#x
I have an instance of what looks like a weird mixup of data returned by the
server.
This is observed in a Java application using the 9.0-801.jdbc4 JDBC driver
connecting to an 8.3.4 server (yes, it's old) running on Solaris.
The application hung waiting for the result of one
select * from a_tabl
On Tue, 2 Nov 2010 10:10:19 -0400, Tom Lane wrote:
> Szymon Guz writes:
> > On 2 November 2010 10:36, AI Rumman wrote:
> >> Is it possible to create an index in descending order?
>
> > create index i on t(i desc);
>
> Note that there is actually no point at all in such a declaration.
> The pla
e it should take a couple minutes
and it takes ten times longer:
Time: 1495549.716 ms
What am I missing?
--
Michal Politowski
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
On Thu, 10 Jun 2010 13:50:23 -0700, Mike Christensen wrote:
> I have a column called "email" that users login with, thus I need to
> be able to lookup email very quickly. The problem is, emails are
> case-insensitive. I want f...@bar.com to be able to login with
> f...@bar.com as well. There's t
On Thu, 25 Feb 2010 09:34:19 +0100, Stefan Schwarzer wrote:
> Hi there,
>
> I have tables with values for each country of the world.
>
> Now, there is the possibility for the user to generate regional
> (Europe, Africa...) or subregional (Western Europe, Central
> Europe...) aggregations on-the-f
On Wed, 15 Apr 2009 15:32:42 +0100, Shug Boabby wrote:
> I simplified my problem a little too much and now I'm stuck trying to
> use cumulative_sum(). My schema is not only A, B but also has a C
>
> A B C
> 1 0 1
> 2 1 1
> 3 0 1
> 4 2 1
> 5 1 1
> 1 0 2
> 2 1 2
> 3 0 2
> 4 2 2
> 5 1 2
>
> and I wa
On Sun, 15 Feb 2009 13:41:05 -0500, Tom Lane wrote:
> Michal Politowski writes:
> > Is it normal that plans using a scan on a partial unique index
> > estimate that much more than one row is returned?
>
> There isn't currently any special logic to recognize that cas
I'm using PostgreSQL 8.3.
Is it normal that plans using a scan on a partial unique index
estimate that much more than one row is returned?
Eg. I see:
-> Bitmap Index Scan on tmp_idx_oss_archive_object_id_current
(cost=0.00..3.12 rows=4189 width=0)
where the tmp_idx_oss_archive_object_id_current
12 matches
Mail list logo
