Obviously, since version 8.4, PostgreSQL allows each database to use a different locale.
So I went to the document to read about the locale (http://www. postgresql .org/docs/8.4/static/locale.html)
Author: Simo
PostgreSQL – How to imitate the Postgres foreign key into the partition table
I have a partitioned table (call it A) where a serial primary key is referenced by another table (call it B). I know I can’t actually go from one to the other One creates a foreign key (because I d
PostgreSQL – How to trigger columns in another table?
So I am adding the last updated database time for my application server. Our idea is to apply the record update to the time of one of our trips, and then the application can send it to get Request
Day41 – numeric type, integrity constraint
day41 Numeric type Integer type
mysql> create table t1(id tinyint); # The default is signed, that is, there is a sign before the number Unsigned setting mysql> create table t1(id tinyint uns
Nosql: MongoDB or BigTable is not always “available”
Read Nathan Hurst’s Visual Guide to NoSQL Systems, he includes the CAP triangle:
>Consistency
>Availability
> Partition tolerance
SQL Server is an AC system, and MongoDB is a CP system.
Why do we use NOSQL?
Knowing some of the advantages provided by NoSQL (scalability, usability, etc.), I still don’t know why a website wants to use a non-relational database.
Can I get some help, is it best to use an
Data Warehouse – Data Warehouse Principle and NOSQL
Using MongoDB, CouchDB and related technologies, we can query faster, is this still valid?
“A copy of transaction data, specifically for query and analysis.” (R. Kimball The Data Warehouse To
Riak performance – unexpected results
In the last days, I had a fight with Riak. The initial setup was easier than I thought. Now I have a 3-node cluster. For testing purposes, all nodes are running on the same vm.
I admit that t
How many data have each node in the NOSQL – Cassandra cluster?
When do the boundaries of SSTables compression (primary and secondary) become invalid?
If I have the main compression of 500G SSTables and my final SSTable will exceed 1TB-is this effective f
PostgreSQL – PG_RESTORE: [Archiver] Input file is too short in Postgres
I am trying to dump the database in my local system by using the command:
pg_restore –host=localhost- -port=5432 –dbname=dev_db –no-owner –no-privileges db_dump_new.backup But I get an er