Hi Sushant,
i think the problem is that we miss check constraints.
We will implement asap
For the moment thank you to everybody for the excellent support!
/F
What is the execution plan of a query is showing? Check whether it is
reading through all partitions.
Best Regards,
*Sushant Pawar | Database Solution Consultant*
*ASHNIK TECHNOLOGY SOLUTIONS PVT. LTD.*
Skype: sush_531 | T: +91 9769559995 <%2B65%206438%203504> | www.ashnik.com
On Tue, Feb 21,
Do you have non overlapping check constraints on the partitions by date to
allow the planner to exclude the child tables from needing to be looked at?
Hu guys,
we have a test machine with Postgresql 9.6.1 an about 800.000.000 record in a
table.
Table is partitioned by day, with indexes on partitioned table.
Also a simple query (for example i want to search log occurred in a specific
day), is immediate in tha partitioned table (table_2017_02_1
[...]
> I need to search a table to find sets of rows that have a column
matching
> itself for the whole set and another column matching row for row with a
> list I am going to supply. The result I should receive should be
value of
> the column that matches itself.
[...]
How about:
DROP TAB
Le 18/06/2011 23:51, Daron Ryan a écrit :
Hello,
I need to search a table to find sets of rows that have a column
matching itself for the whole set and another column matching row for
row with a list I am going to supply. The result I should receive should
be value of the column that matches it
Thanks.
On 19/06/2011 8:09 AM, David Johnston wrote:
An alternative approach would be to select using a IN condition on the where
clause and group by column 1 and column 2. Then, using this as a sub-select
group by the resultant column 1 and a count on column two. The matching
identifiers a
An alternative approach would be to select using a IN condition on the where
clause and group by column 1 and column 2. Then, using this as a sub-select
group by the resultant column 1 and a count on column two. The matching
identifiers are those with a count equal to the number of entries in
Untested approach
Use array_agg on column 2 along with group by on column 1 to build check arrays
and then use equals to compare with an array of your desired input values.
You should omit duplicates and order ascending both the data and the input to
ensure you are matching canonical forms.
Dav
Hello,
I need to search a table to find sets of rows that have a column
matching itself for the whole set and another column matching row for
row with a list I am going to supply. The result I should receive should
be value of the column that matches itself.
For example given the following
hael Hull
>> Cc: pgsql-general@postgresql.org
>> Subject: Re: [GENERAL] Search then Delete Performance
>>
>> On 09/14/10 5:55 PM, Michael Hull wrote:
>> > So fairly simply, I have a daemon running on a machine, which
>> accesses
>> > this DB. Clients connect an
> -Original Message-
> From: pgsql-general-ow...@postgresql.org [mailto:pgsql-general-
> ow...@postgresql.org] On Behalf Of John R Pierce
> Sent: Tuesday, September 14, 2010 8:41 PM
> To: Michael Hull
> Cc: pgsql-general@postgresql.org
> Subject: Re: [GENERA
On 09/14/10 5:55 PM, Michael Hull wrote:
So fairly simply, I have a daemon running on a machine, which accesses
this DB. Clients connect and request the details for say 1000
simulations, at which point the daemon takes 1000 entries from the
unassigned table and moves them to the assigned table.
Michael Hull writes:
> I am fairly new to practical databases, but I am trying out the c
> interface to postgres and am wondering how to improve performance. I
> am a researcher, and I am trying to perform a large parameter sweep.
> Since this will involve a couple of thousand simulations, I have
Hi,
It's probably slow because you run many queries where a few would work:
DELETE FROM unassignedjobs WHERE jobid IN (6, 8 ,2, 99, 66)
But I wouldn't know how to build a query like that in C. A script in
python or even bash that dit it would be faster than your C
implementation.
What you can d
Hi Everyone,
I am fairly new to practical databases, but I am trying out the c
interface to postgres and am wondering how to improve performance. I
am a researcher, and I am trying to perform a large parameter sweep.
Since this will involve a couple of thousand simulations, I have a
process that ma
There are renamed tables with one leading underscore sitting on the system
right now. I don't know how many mechanisms there are for renaming, as this
renaming (until now) was done from a "rename" function within pgAdmin or EMS
PG-SQL Manager - this is the first time I can think of having explic
Carlo Stonebanks wrote:
> When I try the following command:
> ALTER TABLE mdx_core.audit_impt RENAME TO _audit_impt;
>
> I get the error message:
>
> ERROR: type "_audit_impt" already exists
> SQL state: 42710
Probably the easiest way around this is to use two underscores instead
of one:
ALTER
Sam Mason writes:
> On Wed, Nov 04, 2009 at 11:31:55AM -0500, Carlo Stonebanks wrote:
>> When I try the following command:
>> ALTER TABLE mdx_core.audit_impt RENAME TO _audit_impt;
>>
>> ERROR: type "_audit_impt" already exists
You aren't going to be able to do that, because of the conflict with
On Wed, Nov 04, 2009 at 11:31:55AM -0500, Carlo Stonebanks wrote:
> When I try the following command:
> ALTER TABLE mdx_core.audit_impt RENAME TO _audit_impt;
>
> ERROR: type "_audit_impt" already exists
>
> How do I search the system catalogs to find this particular "type"?
select typname, ty
When I try the following command:
ALTER TABLE mdx_core.audit_impt RENAME TO _audit_impt;
I get the error message:
ERROR: type "_audit_impt" already exists
SQL state: 42710
I have looked through tables, types, sequences etc. I even did a PLAIN
schema (no data) backup on the DB and did a text se
: Matthew Seaborn
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] Search Path vs Synonyms
On Fri, Jul 24, 2009 at 09:38, Matthew
Seaborn wrote:
> Ah, I am actually using EnterpriseDB (a commercial 'fork' of PSQL) which does
> have synonyms.
For support on EnterpriseDB yo
On Fri, Jul 24, 2009 at 09:38, Matthew
Seaborn wrote:
> Ah, I am actually using EnterpriseDB (a commercial 'fork' of PSQL) which does
> have synonyms.
For support on EnterpriseDB you should contact EnterpriseDB, not the
PostgreSQL community. We can only answer about the opensource product.
> Is
Matthew Seaborn wrote:
Ah, I am actually using EnterpriseDB (a commercial 'fork' of PSQL) which does
have synonyms.
then you likely will get more help from EnterpriseDB's technical
support, as only they are really familiar with their proprietary and
commercial product.
--
Sent via pg
orn; pgsql-general@postgresql.org
Subject: RE: [GENERAL] Search Path vs Synonyms
Matthew Seaborn wrote:
> Given the situation where a user connecting to the database
> needs access to two separate schemas: the primary schema
> which contains the data they will be updating and a second
>
Matthew Seaborn wrote:
> Given the situation where a user connecting to the database
> needs access to two separate schemas: the primary schema
> which contains the data they will be updating and a second
> schema which contains read-only reference data, used by many
> users, that will be using
Given the situation where a user connecting to the database needs access to two
separate schemas: the primary schema which contains the data they will be
updating and a second schema which contains read-only reference data, used by
many users, that will be using in joins on queries.
I don't wan
On Fri, Jun 12, 2009 at 7:58 AM, James B. Byrne wrote:
>
> On Thu, June 11, 2009 17:37, Andy Colson wrote:
>
>> That's a little vague, so how about:
>>
>> select * from somethine where (extract(year from idate) = $1) or
>> (extract(year from idate) = $2 and extract(month from idate) = $3)
>> or (ex
On Fri, Jun 12, 2009 at 12:47:26AM +0200, Leif B. Kristensen wrote:
> CREATE OR REPLACE FUNCTION date2text(DATE) RETURNS TEXT AS $$
> -- removes hyphens from a regular date
> SELECT
> SUBSTR(TEXT($1),1,4) ||
> SUBSTR(TEXT($1),6,2) ||
> SUBSTR(TEXT($1),9,2)
> $$ LANGUAGE sql STABLE;
Why
On Thu, June 11, 2009 17:37, Andy Colson wrote:
> That's a little vague, so how about:
>
> select * from somethine where (extract(year from idate) = $1) or
> (extract(year from idate) = $2 and extract(month from idate) = $3)
> or (extract(year from idate) = $4 and extract(month from idate) = $5
>
On Thursday 11. June 2009, James B. Byrne wrote:
>Given a datetime column, not null, is there a single syntax that
>permits searching for all dates in a given year, year+month, and
>year+month+day such that a single parameterised query can handle all
>three circumstances?
Apart from the other exce
James B. Byrne wrote:
Given a datetime column, not null, is there a single syntax that
permits searching for all dates in a given year, year+month, and
year+month+day such that a single parameterised query can handle all
three circumstances?
That's a little vague, so how about:
select * from
On Thu, Jun 11, 2009 at 2:35 PM, Tom Lane wrote:
> "James B. Byrne" writes:
>> Given a datetime column, not null, is there a single syntax that
>> permits searching for all dates in a given year, year+month, and
>> year+month+day such that a single parameterised query can handle all
>> three circu
"James B. Byrne" writes:
> Given a datetime column, not null, is there a single syntax that
> permits searching for all dates in a given year, year+month, and
> year+month+day such that a single parameterised query can handle all
> three circumstances?
Try date_trunc() ... however, if you want th
On Jun 11, 2009, at 1:23 PM, James B. Byrne wrote:
Given a datetime column, not null, is there a single syntax that
permits searching for all dates in a given year, year+month, and
year+month+day such that a single parameterised query can handle all
three circumstances?
Well, of course, in a
Given a datetime column, not null, is there a single syntax that
permits searching for all dates in a given year, year+month, and
year+month+day such that a single parameterised query can handle all
three circumstances?
--
*** E-Mail is NOT a SECURE channel ***
James B. Byrne
On Thu, Feb 19, 2009 at 01:27:23PM -0500, Rob Richardson wrote:
> Thank you very much. It works, as I'm sure you knew.
>
> But I have a further question. I've never seen the "~*" operator
> before, and searching for it in the docs and on Google did not return
> any results I could find. What do
Thank you very much. It works, as I'm sure you knew.
But I have a further question. I've never seen the "~*" operator
before, and searching for it in the docs and on Google did not return
any results I could find. What does it mean?
Thanks again!
RobR
--
Sent via pgsql-general mailing list
On Thu, Feb 19, 2009 at 12:46:41PM -0500, Rob Richardson wrote:
> Can anyone suggest a query that will tell me the names of all functions
> (both trigger and normal) that contain a given string of text?
assuming you mean pl/* functions, you can simply use:
select proname from pg_proc where prosrc
Greetings!
Can anyone suggest a query that will tell me the names of all functions
(both trigger and normal) that contain a given string of text?
Here's what happened:
My company's database has a table named "charge" and a view named
"availcharges" that returns all charges that are available.
>> Hi there,
>>
>> I want to know how many connections is created simultaneously in data
base
>> per day.
>
>Do you want to know the max simo connections at any given time, or the
>total connections in a given day? Assuming you want to know the max
>simo connections at any given time, I think you'
On Jan 11, 2008, at 11:51 AM, Joshua D. Drake wrote:
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Fri, 11 Jan 2008 14:29:32 -0300
João Paulo Zavanela <[EMAIL PROTECTED]> wrote:
Hi there,
I want to know how many connections is created simultaneously in data
base per day.
Entirely depen
On Jan 11, 2008 11:29 AM, João Paulo Zavanela <[EMAIL PROTECTED]> wrote:
> Hi there,
>
> I want to know how many connections is created simultaneously in data base
> per day.
Do you want to know the max simo connections at any given time, or the
total connections in a given day? Assuming you want
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Fri, 11 Jan 2008 14:29:32 -0300
João Paulo Zavanela <[EMAIL PROTECTED]> wrote:
> Hi there,
>
> I want to know how many connections is created simultaneously in data
> base per day.
Entirely depends on your machine. I wouldn't suggest having more
Hi there,
I want to know how many connections is created simultaneously in data base
per day.
Are there some table where i can search it?
All users is connected in the database with postgres user.
Thanks.
João Paulo Zavanela
---(end of broadcast)---
Ow Mun Heng <[EMAIL PROTECTED]> writes:
> Why is this such or is this an intended feature?
No, there is no intention that ALTER ROLE SET values be inherited ---
what you get is just what is attached to the role you logged in as.
What would you do with conflicting sets from different inherited role
On Thu, 2007-11-01 at 00:02 -0400, Tom Lane wrote:
> Ow Mun Heng <[EMAIL PROTECTED]> writes:
> > Why is this such or is this an intended feature?
>
> No, there is no intention that ALTER ROLE SET values be inherited ---
> what you get is just what is attached to the role you logged in as.
> What
CREATE ROLE db_users
NOSUPERUSER INHERIT NOCREATEDB NOCREATEROLE;
ALTER ROLE db_users SET search_path=mydb, public;
When I create a login,
CREATE ROLE oli LOGIN
ENCRYPTED PASSWORD 'mXXX'
NOSUPERUSER INHERIT NOCREATEDB NOCREATEROLE;
ALTER ROLE oliver SET search_path=xmms; < I have to set
Postgres User wrote:
I have a table of around 6,000 places in the world. Everytime my
server receives a ping, I'm grabbing the content of an article from an
RSS feed. Then I search the article for the presence of any the 6000
terms.
A typical article is around 1200 words.
I don't need to save
On Jul 2, 2007, at 3:36 PM, Postgres User wrote:
I have a table of around 6,000 places in the world. Everytime my
server receives a ping, I'm grabbing the content of an article from an
RSS feed. Then I search the article for the presence of any the 6000
terms.
A typical article is around 1200
I have a table of around 6,000 places in the world. Everytime my
server receives a ping, I'm grabbing the content of an article from an
RSS feed. Then I search the article for the presence of any the 6000
terms.
A typical article is around 1200 words.
I don't need to save the article in a table
Oscar Picasso wrote:
I guess I also need a database of the cities coordinates. Where could
I find one?
You can download US data here:
http://geonames.usgs.gov/domestic/download_data.htm
These are tables of geo entities with a number of columns, including
lat/long. NGA (formerly NIMA) has
Oscar Picasso wrote:
HI,
I would like to implement a search by distance to my application.
Something like (pseudo sql):
select * from users
where users.location is less than 15 miles from chicago.
Any documentation on how to implements that?
I guess I also need a database of the cities coor
HI,I would like to implement a search by distance to my application.Something like (pseudo sql):select * from userswhere users.location is less than 15 miles from chicago.Any documentation on how to implements that?I guess I also need a database of the cities coordinates. Where could I find one?Tha
Michael Fuhr wrote:
On Mon, Jan 24, 2005 at 08:35:45PM -0800, Benjamin Smith wrote:
Is there a way in PG 7.3, given a field, to find out what other tables &
records are linked to it via a foreign key?
The pg_constraint table contains, among other things, foreign key
constraints. By querying it an
On Mon, Jan 24, 2005 at 08:35:45PM -0800, Benjamin Smith wrote:
> Is there a way in PG 7.3, given a field, to find out what other tables &
> records are linked to it via a foreign key?
See the "System Catalogs" chapter in the documentation:
http://www.postgresql.org/docs/7.3/static/catalogs.htm
Is there a way in PG 7.3, given a field, to find out what other tables &
records are linked to it via a foreign key? EG:
create table cities (id serial primary key,
title varchar not null);
insert into cities(title) values ('San Fransisco');
insert into cities(title) values ('Los Angeles');
Vitaly Belman <[EMAIL PROTECTED]> writes:
> In Oracle I was used to be able to search directly in code from SQL
> Navigator (I'm not sure if it is a feature of the database or the
> tool). It means that I could search if a certain string appears in one
> of the functions (across different schemas/p
In Oracle I was used to be able to search directly in code from SQL
Navigator (I'm not sure if it is a feature of the database or the
tool). It means that I could search if a certain string appears in one
of the functions (across different schemas/packages).
Is there some way to accomplish this in
Merrall, Graeme wrote:
I don't think there's an easy way to do this but I thought I better ask just in case. I'm trying to come up with a way to search across a number of databases without resorting to lots of horrible scripts. In one database I have a lot of news stories from our news provider wh
> On Sun, 1 Feb 2004, Merrall, Graeme wrote:
>
> >
> > I don't think there's an easy way to do this but I thought
> I better ask just in case. I'm trying to come up with a way
> to search across a number of databases without resorting to
> lots of horrible scripts. In one database I have a lo
Why not use schema and single search table contains indices from
different schemes (use trigger to update search table)
On Sun, 1 Feb 2004, Merrall, Graeme wrote:
>
> I don't think there's an easy way to do this but I thought I better ask just in
> case. I'm trying to come up with a way to sear
I don't think there's an easy way to do this but I thought I better ask just in case.
I'm trying to come up with a way to search across a number of databases without
resorting to lots of horrible scripts. In one database I have a lot of news stories
from our news provider while in another data
On Sat, 27 Jan 2001, Marc SCHAEFER wrote:
> Hi,
>
> I wanted to try in the archives how to store a md5sum best in a database
> (origin is 16 bytes binary, if I don't get a good answer I will use ASCII
> like the output of the md5sum UNIX command since this is easy to debug).
>
> I got this error:
Hi,
I wanted to try in the archives how to store a md5sum best in a database
(origin is 16 bytes binary, if I don't get a good answer I will use ASCII
like the output of the md5sum UNIX command since this is easy to debug).
I got this error:
Not Found The requested URL /mhonarc/pgsql-general/se
After cursing over this for I don't know how long, its was recently
brought to my attention that the C search.cgi that comes with UDMsearch
just might not be up to snuff, compared to some of the other interfaces
...
After some investigation, we've installed a mod_perl front-end to the
database t
Hello everyone,
I have he following situation:
I have a 'base' table called Problem and 5 other tables that inherit
Problem: MultipleChoiceProblem, TrueFalseProblem, EssayProblem,
NumericProblem and MatchProblem
I want to do the following query:
SELECT * FROM Problem;
But Problem is empty,
I would like to be able to use searches that seem somewhat intelligent.
Can you 'ORDER BY' number of matching 'OR' clauses? For example, someone
searches for "x y z", so I would do "select * from mytable where col1
like '%x%' or col1 like '%y%' or col1 like '%z%';", but I want it to
order by numbe
Hi,
I want to find information into your search engine for postgresql
mailing
list but I can't find any answer to my search.
Typing SELECT or CURSOR or any other words in pgsql-general or pgsql-sql
give me no output. Perhaps you have an indexation problem ?
Regards
At 03:43 +0300 on 01/08/1999, Gilles Darold wrote:
> I don't know about windows-1251. Perhaps this can't help you. But if
> you have japanese in you database, you can proceed a search on it so
> why not windows-1251 ?
Because the backend has to know that the lowercase for char NNN in this
codep
Hi,
For case insensitive you must use the regexp search as follow :
SELECT title, firstname, lastname, description FROM stuff
WHERE title *~ '.*.*' AND firtsname *~ '.*.*';
>
> P.S.: as far as I know there is no locale for windows-1251 and,
> unfortunately, I can't store data in koi8-r w
Greetings,
I store text data in windows-1251 encoding in my pgSQL database
and when I execute SQL command like
SELECT title, firstname, lastname, description FROM stuff
WHERE title LIKE '%%' AND firtsname LIKE '%%'
AND lastname LIKE '%%' AND description LIKE '%%'
the response comes reall
Wim Ceulemans wrote:
> Hi
>
> Has anyone any experience whether it is possible to build with a PostgreSQl
> database and a linux box a search engine for a portal?
>
i'm doing this. It's name will be GOLIATH
>
> Regards
>
> Wim Ceulemans - [EMAIL PROTECTED]
> Nice Software Solutions - http://ww
73 matches
Mail list logo