Ok, I tried to modify the example functions get_data_alternative_a() and
get_data_alternative_b(), so that they start with SPI_connect, and end with
SPI_finish. Also I removed SPI_connect and SPI_finish from the main function.
As I understand you, that should have solved the problem. The result,
Hi.
Test case look like:
create table "references" ( attr_id integer, reference integer,
object_id integer );
insert into "references" select *100**(random()),
*10**(random()^*10*), *100**(random()) from
generate_series(*1*,*1000*);
create index xif01references on "references" ( refer
The following bug has been logged online:
Bug reference: 5886
Logged by: muthu
Email address: dbamu...@gmail.com
PostgreSQL version: 9.0.2
Operating system: unbuntu 8.0
Description:pgbench usage
Details:
i want to change the max clients and max threads in pgbench..i
"muthu" wrote:
> i want to change the max clients and max threads in pgbench..is it
> possible in postgres...then how?
> default is 1 thread and 1 client
http://www.postgresql.org/docs/current/interactive/pgbench.html
In the future, please post such questions to pgsql-general or
pgsql-novice
Maxim Boguk writes:
> Test case look like:
> create table "references" ( attr_id integer, reference integer,
> object_id integer );
> insert into "references" select *100**(random()),
> *10**(random()^*10*), *100**(random()) from
> generate_series(*1*,*1000*);
> create index xif01refe
The following bug has been logged online:
Bug reference: 5887
Logged by: Nick Baryshnikov
Email address: warst...@list.ru
PostgreSQL version: 8.4.7
Operating system: Ubuntu 10.10
Description:EXPLAIN returns more than 1000 rows when table is empty
Details:
CREATE TAB
"Nick Baryshnikov" writes:
> Description:EXPLAIN returns more than 1000 rows when table is empty
This is not a bug; it's intentional behavior. As long as the recorded
size of the table is zero, the planner assumes that information is
probably obsolete.
regards, t
Understood. Can you show me where it is written in the documentation?
(I just want to know is, whether it is in the documentation and if not,
probably should add this case)
Tue, 15 Feb 2011 14:52:17 -0500 письмо от Tom Lane :
> "Nick Baryshnikov" writes:
> > Description:EXPLAIN returns
