I have a list-based partition table and I want to prevent scanning of all
children tables in a JOIN, which is using the partition column. I know
that CHECK constraints are not used in this case so I hope that creating an
index on the partition column would help. But I am not sure if I should
On Wed, Mar 4, 2015 at 4:50 AM, Bill Moran wmo...@potentialtech.com wrote:
On Wed, 4 Mar 2015 14:05:09 +0400
Alexander Shutyaev shuty...@gmail.com wrote:
Thanks for the answer. Now, given this info I've calculated that our
postgresql should occupy approx. 30,53 GB while the server has 125 GB
On 3/4/2015 7:03 AM, María Griensu wrote:
I need to figure out how can I weight BLOB objects in a table of a DB,
I'm not expert on this topics, so I appreciate any help you can give me.
postgres's equivalent of BLOB is BYTEA. I'm not sure what you mean
by 'weight' here.
--
john r pierce
Hi Alexander:
On Wed, Mar 4, 2015 at 11:05 AM, Alexander Shutyaev shuty...@gmail.com
wrote:
Thanks for the answer. Now, given this info I've calculated that our
postgresql should occupy approx. 30,53 GB while the server has 125 GB of
RAM. However we often see in top that there is very little
Hello,
I have a rather big query which should match id's from various tables
together. To be able to use multiprocessing I'm currently using
postgresql 9.5-dev, because of the SKIP LOCKED feature.
SELECT
start,
destination,
ST_Distance(start_geom, end_geom) AS distance_meter
FROM (
Here's the answer.
http://pdenya.com/2014/01/16/postgres-bytea-size/
El 04/03/15 a las 12:17, John R Pierce escibió:
On 3/4/2015 7:03 AM, María Griensu wrote:
I need to figure out how can I weight BLOB objects in a table of a
DB, I'm not expert on this topics, so I appreciate any help you can
On Wed, 4 Mar 2015 12:36:36 -0300
María Griensu mdovale.grie...@gmail.com wrote:
Thanks, I mean, how heavy it is in kB.
If you mean how much overhead is involved in storing the data, that's
a bit complicated.
First off, how the data is stored depends on the size of it, and what
other fields
Circling back on this one, I had a look at our analyze code. I found
one place where *maybe* we weren't freeing memory and freed it, but
analyzing a 2M record table I barely see any bump up in memory usage
(from 22M up to 24M at peak) during analyze. And the change I made
didn't appear to alter
Paul Ramsey wrote
Though maybe with a really big table? (with really big
objects?) Though still, doesn't analyze just pull a limited sample
(30K approx max) so why would table size make any difference after a
certain point?
Hi paul, my table is quite big (about 293.049.000 records) but the
Thanks, I mean, how heavy it is in kB.
2015-03-04 12:17 GMT-03:00 John R Pierce pie...@hogranch.com:
On 3/4/2015 7:03 AM, María Griensu wrote:
I need to figure out how can I weight BLOB objects in a table of a DB, I'm
not expert on this topics, so I appreciate any help you can give me.
Roxanne Reid-Bennett wrote
Most definitely ask on the Postgis list. Identify the full Postgis
version and Postgres versions as well.
Hi Roxanne,
seconds before sending it to the postgis-list i checked the table
planet_osm_ways and there is no geometry:
That can't be a postgis problem. I'll
Stop writing so many subqueries, think in joins; the poor planner!
SELECT DISTINCT ON (a.id) a.id AS a_id, b.id AS b_id
FROM a
JOIN b
ON ST_Contains(b.shape, a.shape)
WHERE b.kind != 1
Also, the DISTINCT ON syntax (PgSQL custom) lets you winnow a result
set down to just one of the inputs.
P.
I would like to stop executing the query for a row of table a when a
single row of b is found. This query would not stop
processing but will filter all the rows that are found at the end of
execution.
Is there a way to express this without a subquery?
On Wed, Mar 4, 2015 at 11:53 PM Paul Ramsey
Hi All,
I am working on setting up a new database server with shared disk and
cluster failover.
In this environment, only one node will be active at a certain time.
Underneath, we are planning to have shared storage with CIFS protocol.
As I am newbie with this storag, can anyone please help me
On 3/4/15 10:12 AM, Bill Moran wrote:
From there, if the data is large enough to trigger out-of-line
storage, the data will be broken down into chunks and stored in a
toast table, this increases the overhead because each row in the
toast table will have it's own overhead, and the number of rows
On 3/4/2015 9:10 PM, AI Rumman wrote:
I am working on setting up a new database server with shared disk and
cluster failover.
In this environment, only one node will be active at a certain time.
Underneath, we are planning to have shared storage with CIFS protocol.
As I am newbie with this
On 3/4/15 9:25 AM, Semyon Reyfman wrote:
I have a list-based partition table and I want to prevent scanning of all
children tables in a JOIN, which is using the partition column. I know
that CHECK constraints are not used in this case
Why do you say that? If properly written and with
I've sketched out a design for a templating system for Postgres, and I'm
looking for feedback from anyone that might be interested in it.
My goal is to allow people to register different template languages in
it (anything that can be loaded in a Postgres procedure language would
work), and
On 04 Mar 2015, at 22:18, Igor Stassiy istas...@gmail.com wrote:
I would like to stop executing the query for a row of table a when a single
row of b is found. This query would not stop
processing but will filter all the rows that are found at the end of
execution.
Is there a way to
Thanks for the answer. Now, given this info I've calculated that our
postgresql should occupy approx. 30,53 GB while the server has 125 GB of
RAM. However we often see in top that there is very little free memory and
even swap is used. What could be the reason of postgres using so much
memory?
Hi,
On 2015-03-04 14:05:09 +0400, Alexander Shutyaev wrote:
Thanks for the answer. Now, given this info I've calculated that our
postgresql should occupy approx. 30,53 GB while the server has 125 GB of
RAM. However we often see in top that there is very little free memory and
even swap is
You have spam on postgresql.org main page...
Jim Smith: Myśli o istotnych Szczegóły kwiatów dostawy online
It's not even proper polish :)
--
View this message in context:
http://postgresql.nabble.com/Spam-on-main-page-tp5840406.html
Sent from the PostgreSQL - general mailing list archive at
On Wed, 4 Mar 2015 14:05:09 +0400
Alexander Shutyaev shuty...@gmail.com wrote:
Thanks for the answer. Now, given this info I've calculated that our
postgresql should occupy approx. 30,53 GB while the server has 125 GB of
RAM. However we often see in top that there is very little free memory
Hello,
I have a query plan optimization question. It is formatted nicely on
http://stackoverflow.com/questions/28856452/postgres-not-using-gist-index-in-lateral-join
But here is a copy for the archive:
Here is the setup:
CREATE EXTENSION postgis;
DROP TABLE IF EXISTS A;
DROP TABLE IF EXISTS
Samuel,
* Samuel Smith (pg...@net153.net) wrote:
I noticed that I could get very nice partition elimination using
constant values in the where clause.
Ex:
select * from table where constraint_col between '2015-01-01'
and '2015-02-15'
However, I could not get any partition elimination
Hi Adrian:
On Wed, Mar 4, 2015 at 1:03 AM, Adrian Klaver adrian.kla...@aklaver.com
wrote:
As you pointed, my bet is in the -f case COPY FROM STDIN expects the
data on the file ( otherwise pg_dumps would not work ), but your
sugestion seems to have a problem of double redirection, let me
I need to figure out how can I weight BLOB objects in a table of a DB, I'm
not expert on this topics, so I appreciate any help you can give me.
Thanks in advance.
Maria.
27 matches
Mail list logo
